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 and value of the cell.
Thanks in advance
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 and value of the cell.
Thanks in advance