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
|