I need a formula like this but cannot find a way to reference the color of the cell used for the logic.
IF CELL COLOR = Yellow, then “yes”, else “no”…
I searched under cell format constants and color constants but cannot seem to find what I need.
TIA
D
