fill a cell color using date in one cell and "yes/no" in another c
Try this...
A1 = some date
B1 = yes or no
C1 = fill with color if A1 = a date <=today and C1 = no
Select cell C1
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the little box to the right:
=AND(COUNT(A1),A1<=TODAY(),C1="no")
Click the Format button
Select the Patterns tab
Select the color of your choice
OK out
--
Biff
Microsoft Excel MVP
"dinocm" wrote in message
...
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!
|