View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Navy Nurse Navy Nurse is offline
external usenet poster
 
Posts: 1
Default Cond format with date

How do you program a cell to change colors by the current date? example: I
need a cell to change color when the input date becomes less than today's
date. (a CPR card expiration date is entered, when todays date is past the
expiration date, I need the cell to turn red to notify that it is expired.
The date used to judge must be the current date, whatever todays date is vs.
a specific date entered.)