View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron A. Ron A. is offline
external usenet poster
 
Posts: 1
Default Conditional Format based on date

I need to have cell A3 to be filled with red and show "within 90 days" based
on the current system date being equal to or less than a date entered in cell
A2. This will notify me that an employee's annual training is due within 90
days.

How might this be done?
--
Aloha,
Ron A.