Auto-format shading color.
 

How do I change the color of the auto-format every other line shading from
grey to a different color in Excel?

Auto-format shading color.
 

John wrote:
How do I change the color of the auto-format every other line shading from
grey to a different color in Excel?

1. Format, Cells, Pattern - take mental note of which grey is being used

2 Tools, Options, Color - click on the grey colour. Modify, and slide the
grey up or down - or select another colour

--
Message posted via http://www.officekb.com

Auto-format shading color.
 

John

The autoformat shading doesn't stick if you delete rows or sort the data.

Better to use Conditional Formatting which doesn't get messed up.

Select a range of rows to format.

FormatCFFormula is =MOD(ROW(),2)=1

Pick a color from FormatPatterns and OK your way out.


Gord Dibben MS Excel MVP

On Fri, 18 Aug 2006 06:22:01 -0700, John wrote:

How do I change the color of the auto-format every other line shading from
grey to a different color in Excel?