CONDITIONAL FORMATTING REFERENCE ERRORS WHEN COPYING PASTE SPECIAL CELLS
lets say I have the following conditional formattingformula in cell D20:
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)
in D21 I get:
and more surprise, in D22 I get:
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
Please attach a document so we can test this out. Marking as NEEDINFO, once the attachment is made please set bug to UNCONFIRMED and we'll take a look at it.
I did not get working the CF, but I see the wrong references. Known problem, DUP of "Bug 60311 - EDITING: Copy cells with CONDITIONAL FORMATTING formula with wrong references after paste"
Please feel free to reopen this Bug if you find evidence that we have an independent issue here (for example because the fix for the other bug does not work for you).
*** This bug has been marked as a duplicate of bug 60311 ***