Conditional Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rosemary - 19 Oct 2006 23:31 GMT

Hello,

Can you copy conditional formatting down a column, and have it change the
cell references like it does with regular formulas?

Cell P2 changes formatting depending on the value of cell I2; Cell P3
changes formatting depending on the value of cell I3; etc.

I set up the conditional formatting in P2, and when I copy the formatting
down the column, the cell reference doesn't change from I2 to I3, I4, etc.
It stays I2.

Thanks,

Reply to this Message

txilya - 20 Oct 2006 00:12 GMT

Hi Rosemary,

When referring to I2 in conditional formatting for P2, change $I$2 to $I2 or
I2.

Ilya

> Hello,
>
[quoted text clipped - 9 lines]
>
> Thanks,

Reply to this Message

Dave Peterson - 20 Oct 2006 00:12 GMT

What did you use in your formula? i2 or $i$2 or i$2 or $i2

Make sure you didn't use $i$2 or i$2.

and you can select P2:P(whatever) and apply the conditional formatting all at
once. But still use the relative reference (i2).

> Hello,
>
[quoted text clipped - 9 lines]
>
> Thanks,

Signature

Dave Peterson

Reply to this Message

Gord Dibben - 20 Oct 2006 00:27 GMT

Yes

When you enter the CF>Formula is: make sure Excel doesn't help by placing $ sign
in the row reference.

You will have to edit out the $ sign if you point to the cell when adding the
CF>Formula is:

If typed, you have control.

Gord Dibben MS Excel MVP

>Hello,
>
[quoted text clipped - 9 lines]
>
>Thanks,

Reply to this Message

Rosemary - 20 Oct 2006 00:56 GMT

Thank you!!

> Hello,
>
[quoted text clipped - 9 lines]
>
> Thanks,

Reply to this Message