Conditional Formatting

  • Thread starter Thread starter Liz Taylor
  • Start date Start date
L

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
 
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
 
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
Click to expand...
 
Back
Top