View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Picodillo Picodillo is offline
external usenet poster
 
Posts: 3
Default how do i highlight a date that is 4+ days old in excel?

I am creating a sales tracking type spreadsheet. I am looking for a formula
that will automatically highlight cells that are older than 4 days, only if
there is no date in the cell to the right of it. The formula should
automatically update as the current date changes and should remove the
highlighting when a date is entered in the next cell to the right