Highlighting Every Other Row - Conditional Formatting - Not Workin

[NicoleS]

Hello,
Here is my original post, which was very helpful:
http://www.microsoft.com/office/com...b8403b-96bb-4c7d-bfb5-a602d4127bde&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

 

[Pete_UK]

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

=MOD(ROW(),2)=1

Hope this helps.

Pete