Formatting Worksheet with Shading on Every Other Row

L

Lauren

I was told that it is possible to automatically format a worksheet in
Excel so that every other row in the worksheet is shaded. I have not
been able to figure out how to do this. Does anyone out there know
how I can do this automatically? Any assistance is greatly
appreciated. Thanks!
 
D

Domenic

To format odd numbered rows...

1) Format > Conditional Format > Formula Is
2) Enter the following formula:
=MOD(ROW(),2)=1
3) Choose your formatting
4) Click Ok

To format even numbered rows, use the following formula instead:

=MOD(ROW(),2)=0

If you want one formatting for odd numbered rows and, at the same time,
another formatting for even numbered rows, you can create two
conditions. After entering the first condition, click on "Add" and add
your second one.

Hope this helps!
 
Top