Conditional Formatting

[Liz Taylor]

Hi,

I want to copy my conditional formating from one cell to another but it's
not doing it the "right" way...

The condition looks at one cell value and then acts accordingly. For
instance it looks at C1 and if C1 is smaller than D1 the D1 color will be
changed to Red. Simple enough. Now, I copy the conditional formatting to my
next cell D2, but the conditioanl formatting is not "updated" so it's still
at C1 instead of C2 and so forth.

What am I doing wrong?

Thanks,

Liz

 

[Gord Dibben]

Liz

Your cell reference in CF is most likely Absolute as in

=$C$1<$D$1

Remove the $ signs if this is the case.

Or select the whole range in Column D before setting the CF Formula is:

Then enter =C1<D1 which will be incremented in each of the cells you selected
in Column D.

Gord Dibben Excel MVP

 

[Liz Taylor]

It works!

Thanks!!

Liz

Liz

Your cell reference in CF is most likely Absolute as in

=$C$1<$D$1

Remove the $ signs if this is the case.

Or select the whole range in Column D before setting the CF Formula is:

Then enter =C1<D1 which will be incremented in each of the cells you selected
in Column D.

Gord Dibben Excel MVP

 

[Gord Dibben]

AAAWWWright!!

Thanks for the feedback.

Gord

It works!

Thanks!!

Liz