Hello,
Here is my original post, which was very helpful:
http://www.microsoft.com/office/comm...bde&sloc=en-us

I am now using Office 2007.
When I try to use the formula =MOD(ROW(),2) for highlighting every other
row, it only highlights alternating BLANK rows. If the row is populated, it
will not highlight it.

Can someone help me figure out why this is happening & how to fix it?

Thanks!
NicoleS

Perhaps it is more strongly typed than earlier versions. Try this
formula instead:

=MOD(ROW(),2)=1

Hope this helps.

Pete

On Dec 4, 8:59*pm, NicoleS wrote:
Hello,
Here is my original post, which was very helpful:http://www.microsoft.com/office/comm....mspx?dg=micro...

I am now using Office 2007.
When I try to use the formula =MOD(ROW(),2) for highlighting every other
row, it only highlights alternating BLANK rows. If the row is populated, it
will not highlight it.

Can someone help me figure out why this is happening & how to fix it?

Thanks!
NicoleS