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

conditional formatting based on proximity to date
 

Use this formula for the conditional formatting, assuming the date is in
column A: Select everything, enter:
=OR(DATE(YEAR($A1),MONTH($A1),DAY($A1))=DATE(YEAR( TODAY()),MONTH(TODAY())-1,
DAY(TODAY())),DATE(YEAR($A1),MONTH($A1),DAY($A1))= DATE(YEAR(TODAY()),MONTH(T
ODAY())-2,DAY(TODAY())),DATE(YEAR($A1),MONTH($A1),DAY($A1) )=DATE(YEAR(TODAY(
)),MONTH(TODAY())-3,DAY(TODAY())),DATE(YEAR($A1),MONTH($A1),DAY($A1) )=DATE(Y
EAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())),DATE(2000,MONTH($A1),DAY($A1))=D
ATE(2000,MONTH(TODAY()),DAY(TODAY())),AND($A1<TODA Y()+14,$A1TODAY()-7))
Bob Umlas

"mato nanjin" wrote in message
...
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

conditional formatting based on proximity to date
 

Bob,

Thank you for this response. I know that I should know this but tell me the
significance of the "2000" in the formula ......())),DATE(2000,MONTH........

Thanks,

Ron

"Bob Umlas" wrote:

Use this formula for the conditional formatting, assuming the date is in
column A: Select everything, enter:
=OR(DATE(YEAR($A1),MONTH($A1),DAY($A1))=DATE(YEAR( TODAY()),MONTH(TODAY())-1,
DAY(TODAY())),DATE(YEAR($A1),MONTH($A1),DAY($A1))= DATE(YEAR(TODAY()),MONTH(T
ODAY())-2,DAY(TODAY())),DATE(YEAR($A1),MONTH($A1),DAY($A1) )=DATE(YEAR(TODAY(
)),MONTH(TODAY())-3,DAY(TODAY())),DATE(YEAR($A1),MONTH($A1),DAY($A1) )=DATE(Y
EAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())),DATE(2000,MONTH($A1),DAY($A1))=D
ATE(2000,MONTH(TODAY()),DAY(TODAY())),AND($A1<TODA Y()+14,$A1TODAY()-7))
Bob Umlas

"mato nanjin" wrote in message
...
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