conditional format fails when copied

  • Thread starter Thread starter oldyork90
  • Start date Start date
O

oldyork90

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
 
Hi,

Am Wed, 8 Jan 2014 07:21:28 -0800 (PST) schrieb (e-mail address removed):
=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.
Click to expand...

if the reference always is G8 you have to set it absolute:
=AND($G$8,(MOD(ROW(),2)=1))


Regards
Claus B.
 
Back
Top