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

[Guest]

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

 

[Guest]

Stefi:

Thank you, that was quite simple. (I hope I remember it the next time I need
this application!!!)

Darrell

 

[Guest]

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:

 

[Guest]

Apply conditional formatting for A1 as follows:

Select formula as condition (instead of cell value)
1st condition: =$X$11="C" choose green
2nd condition: =$X$11="I" choose yellow
3rd condition: =$X$11="X" choose red

Regards,
Stefi



„Dr. Darrell†ezt írta:

 

[Guest]

You are welcome! Thanks for the feedback!
Stefi


„Dr. Darrell†ezt írta: