View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default Excel Used as a Time Sheet

The easiest way would be to apply Conditional Formatting to a cell so
it turns up red if it is blank. You could work a date calculation in
so the cell turns up red if it is blank and the date is before
tomorrow's date (so only today's entry and previous day's entries would
turn up red, as opposed to future dates).