Stefi:

Thanks for the reply.

That would work if I wanted to have the same text in Cell A1 and Cell X11,
but I don't.

I want to type a date into Cell A1 and have the color the same as Cell X11.

I have 3 conditions:

If Cell X11="C", Green
If Cell X11="I", Yellow
If Cell X11="X", Red

Darrell

"Stefi" wrote:

I should apply the same conditional formatting criterium for A1 as for X11.
If you post the criterium, I'll try to extend it to cell A1.

Regards,
Stefi


€žDr. Darrell€� ezt Ã*rta:

I have a spread sheet where Cell X11 has conditional formatting allowing it
to be Green, Yellow or Red.

I would like Cell A1 to change color and always be the same color as Cell X11.

Is there a function that does this?

Darrell