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
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
> Someone told me you can use Format/Conditional Formatting and selecting
> the Formula is criteria to create a worksheet in which every other row
> is shaded. I can't seem to do it. Can anyone help?
>
> ---
> Message posted from http://www.ExcelForum.com/