Hi Rosemary,

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

Ilya


"Rosemary" wrote:

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,