Copying conditional formating
 

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.

Copying conditional formating
 

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.

Copying conditional formating
 

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.