View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Knee2no Knee2no is offline
external usenet poster
 
Posts: 3
Default Tracking Dates For Future Occurrences

Can this be done? I want to track a yearly review. I would like the date,
once entered - say 6/1/2009, to conditionally format to change yellow 30 days
before, then red 15 days before, and then to stay red until the date is
updated again for say 6/1/2010. Can this be done? I am new to all this,
thanks..