View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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!