fill a cell color using date in one cell and "yes/no" in another c
I want to use two different cells in a single row (one a date-formatted cell
& one a "Yes/No" text value cell) to display a cell fill color in a third
cell - based on the conditions (e.g., date is <= today and text is "no" -
filling third cell with red) present;
How can I do this?
Txs!
|