View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
smack smack is offline
external usenet poster
 
Posts: 13
Default Empty Cell-conditional formatting

I have a column where I enter a date when a document arrives. If it is left
blank for more than 7 days I need an alert. I also have a start date in A1
to refer to. It would be 7 days from the start date, I would need the cell
red or "ALERT".

Thanks!

SMack