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.
Bookmarks