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
|