CONDITIONAL FORMATTING REFERENCE ERRORS WHEN COPYING PASTE SPECIAL CELLS
lets say I have the following conditional formattingformula in cell D20:

AND(D20<0,A20<>"x")

if this condition is true then D20 turns red

now I copy this cell and paste it into D21 and D22 (only format paste special)

Surprise!

in D21 I get:

AND(D22<0,A21<>"x")

and more surprise, in D22 I get:

AND(D24<0,A22<>"x")

The right formulas should have been:
in D21:   AND(D21<0,A21<>"x")
in D22:   AND(D22<0,A22<>"x")

If you have only one condition in a formula like IF(A20<>"x") the paste has no bug, but you can't paste formulas with more than one condition!

I hope this helps

regards,

Maximo