View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mato nanjin mato nanjin is offline
external usenet poster
 
Posts: 9
Default conditional formatting based on proximity to date

I know that similar posts have been here before, sorry, but htis is a little
different. I need to conditioanally format a row if the anniverary date of
the person in that row is:

within 2 weeks of today OR the anniversary occured within the last week.

AND I need it for the following anniverary:
1 month
2 months
3 months
6 months
any annual anniverary.

Am I asking this to where it makes sense? Thanks,

Ron