Check out chip Pearson's site: http://cpearson.com/excel/banding.htm

--
Hth

Kassie Kasselman


"Louise B." wrote:

Hello all,

Can anyone tell me how to shade every other rows. There must be a way so
that one row is non shaded and the other is without me having to do them all
manually. If it is a formula, please provide it : i go nutts doing those.

Thank you so much, happy new year!

Louise