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


"Homero Noboa" wrote:

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.

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

On Wed, 23 Dec 2009 12:40:02 -0800, Homero Noboa
wrote:

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.