You'd have to do this with some macro code. Excel simply was never created
to make decisions based on cell shading or border color or style or anything
like that; it makes decisions based on the value/content of cells.

Now, if A2 is formatted gray via Conditional Formatting, we could probably
figure out how to set up F2 to display "YES" at the same time that A2 gets
turned gray. The question would be what is the condition that causes A2 to
turn gray.

"pcor" wrote:

I want to place the word "YES" in cell F2 if the cell A2 background is gray.
How do I do that Thanks