View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron A.[_2_] Ron A.[_2_] is offline
external usenet poster
 
Posts: 4
Default Conditional Format Based on Date

How can I change the fill color of a cell based on a date. I would like the
cell to be green if the date in a cell is equal to or greater than 90 days
from todays date. Yellow if less than or equal to 90 days and Red if less
than or equal to 30 day from the current date. This is to track when an
employee's annual training is due.

--
Aloha,
Ron A.