View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dinocm dinocm is offline
external usenet poster
 
Posts: 3
Default 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!