See www.cpearson.com/excel/banding.htm for examples.


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


"Century12" <u21889@uwe wrote in message
news:604cb17cf0ff1@uwe...
This does not give me the ability to alternate colors. What am
I doing wrong?


Bernard Liengme wrote:
Use Format|Conditional Formatting rather than 'hard" colours.
Select the range of row to format and use
Formula Is =MOD(ROW(),2)=1 and select some pattern colour
best wishes
I have set up an excel file in which I have colored every
other line grey.
I
[quoted text clipped - 6 lines]

Thanks!