Alternating colors for rows
 

I'd like to be able to have alternating colors for each of my rows. Example
(gray-blue-gray-blue etc.). If I just change the color of the row then the
change around when I do a sort. Is there a way to lock these colors in place?

Thanks

See www.cpearson.com/excel/banding.htm for a way to do this with
Conditional Formatting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"jp" wrote in message
...
I'd like to be able to have alternating colors for each of my
rows. Example
(gray-blue-gray-blue etc.). If I just change the color of the
row then the
change around when I do a sort. Is there a way to lock these
colors in place?

Thanks