Can I create a Conditional Formula based on the Color of a Cell?

[ayeshabux]

I am I'm trying to create a formula that changes the color of Cell F4 based on the color of the cell in F4;

If F4 cell colour is green or gold and value is of T4 is Y then colour T4 green.
This means:
If Cell F4 = [the color green] && T4=='Y'
then Cell T4 also gets the color green i.e Cell F4 = [the color green]


This is conditional based on the cell fill color.

[6StringJazzer]

You cannot do this without macros. There is no built-in Excel function that will tell you the fill color of a cell. You would have to write a VBA function to return the fill color, then call that function in your conditional formatting rule. UNLESS the color in F4 is determined by conditional formatting, in which case you simply use the same logic in your other rule.