Make a greenbar page in Excel using Conditional Formatting

[dsample]

Someone told me you can use Format/Conditional Formatting and selectin
the Formula is criteria to create a worksheet in which every other ro
is shaded. I can't seem to do it. Can anyone help

 

[Anne Troy]

Chip Pearson shows how here:
http://www.cpearson.com/excel/banding.htm

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->