G Guest Aug 18, 2006 #1 How do I change the color of the auto-format every other line shading from grey to a different color in Excel?
How do I change the color of the auto-format every other line shading from grey to a different color in Excel?
G GRM via OfficeKB.com Aug 18, 2006 #2 John said: How do I change the color of the auto-format every other line shading from grey to a different color in Excel? Click to expand... 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
John said: How do I change the color of the auto-format every other line shading from grey to a different color in Excel? Click to expand... 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
G Gord Dibben Aug 18, 2006 #3 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. Format>CF>Formula is =MOD(ROW(),2)=1 Pick a color from Format>Patterns and OK your way out. Gord Dibben MS Excel MVP
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. Format>CF>Formula is =MOD(ROW(),2)=1 Pick a color from Format>Patterns and OK your way out. Gord Dibben MS Excel MVP
