Copying conditional formating

[Homero Noboa]

Question:
I want every cell in row 2 to have red background if its value is different
than the corresponding cell in row 1.
I can do this to cell A2 if in the conditional formatting field I say
=A2<>A1 but when I copy the formatting (using the brush), the condition
continues to be A2<>A1 and not B2<>B1 for cell B and so forth.
How do I copy the conditional formatting adjusting the references like the
copy cells command do?
Thanks.

 

[מיכ×ל (מיקי) ×בידן]

1) Select all relevant cells in row 2.
2) Choose "Conditional Formating" > by Formula > type: =A2<>A1 > declare a
color > OK
Micky

 

[Gord Dibben]

Are you sure Excel hasn't helped you by placing $ signs in your formula?

Has a habit of changing CF formulas to =$A$2<>$A$1

Remove the $ signs to this

=A$2<>A$1

What I do is select all the cells before I enter the formula.

Then I don't have to paintbrush it across.


Gord Dibben MS Excel MVP