Report Offensive Message

Re: Use conditional formatting to add shading to rows or columns in an Exce
I have often wondered how to highlight every second or third row. I've been doing it the hard way, formatting each row one at a time. I played around with this and discovered I don't have to format the entire sheet but can highlight a certain range also.

Thanks Susan,
Barry
Pro
Posted by bhkolts@...
14th Jan 2009