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