View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MCouture MCouture is offline
external usenet poster
 
Posts: 2
Default Conditional Formatting based on Today's Date

Hi,
I am making a spreadsheet with due dates and completion dates on it. I want
to format the due dates to show up as on-time (green) or late (red) based on
today's date. Once the step is completed (a completed date is entered) I want
the color to stop changing based on today's date (and just stay the color it
was at time of completion.
Thanks