Auto-format shading color.

G

Guest

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

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If using =MOD(ROW(),2)=0 conditional formatting and want diff fill 1
Word Dashed line formatting 0
Unchecking "Extend data range formats" is not workingfor row shading 1
show fill color of a shaded row 3
Partial Shading in Excel 2003 4
Can you shade one cell 2 different colors? 1
Auto-Format Cell Shading 2
conditional formatting 1

Top