Hi!

If you want to shade the odd rows:

=MOD(ROW(),2)=1

If you want to shade the even rows:

=MOD(ROW(),2)=0

Biff

"Exceluser" wrote in message
...
I need to alternate cell shading based on the row number(even, odd). I
need
to know how to do this using the MOD with the Row function as argument. I
am
using Excel in Office XP version 2002.

Thanks