Copying conditional formating

  • Thread starter Thread starter Homero Noboa
  • Start date Start date
H

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
 
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
 
Back
Top