I am formatting cells based on the following equations

=AND(G8,(MOD(ROW(),2)=1))
=AND(G8,(MOD(ROW(),2)=0))
=AND(NOT(G8),(MOD(ROW(),2)=1))
=AND(NOT(G8),(MOD(ROW(),2)=0))


G8 is true or false.

If I hand enter these rules for each cell it works fine, but if I try to copy
the format rules they fail to work correctly.

I've opened the copied and failing cells and viewed each rule. Then look
correct. They appear identical to the original.

I've moved each equation from the copied cell to a stand alone cell
on the side and displayed the value of the result, true
or false. The values when calculated outside of the conditional format
environment are correct.

"Applies to" definitions are also correct.

Any ideas?

excel 2010