software

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


Hi Exceluser,

See www.andrewsexceltips.com/menu...r_set_rows.htm

Gos-C--
Gos-C------------------------------------------------------------------------
Gos-C's Profile: www.excelforum.com/member.php...oamp;userid=14518
View this thread: www.excelforum.com/showthread...hreadid=511432Here you go:

cpearson.com/excel/banding.htm

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Exceluserquot; wrote:

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

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

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