Conditional Formatting Dates Less Than 14 Years Ago

[rsexcel]

I need to conditionally format all dates in a column less than 14 year
from today. Example: Today is 7/11/2012 so all dates from 7/12/1998 t
the present need to be highlighted via conditional formatting.

Data resides in column I and the first cell w/ data is I3. I'm usin
Excel 2010 on Windows XP.

Thanks so much for any assistance you can provide

 

[Claus Busch]

Hi,

Am Wed, 11 Jul 2012 12:55:00 +0000 schrieb rsexcel:

I need to conditionally format all dates in a column less than 14 years
from today. Example: Today is 7/11/2012 so all dates from 7/12/1998 to
the present need to be highlighted via conditional formatting.

Data resides in column I and the first cell w/ data is I3

formula in CF:
=I3>DATE(YEAR(TODAY())-14,MONTH(TODAY()),DAY(TODAY()))


Regards
Claus Busch

 

[rsexcel]

Hi,

Am Wed, 11 Jul 2012 12:55:00 +0000 schrieb rsexcel:
-

formula in CF:
=I3>DATE(YEAR(TODAY())-14,MONTH(TODAY()),DAY(TODAY()))


Regards
Claus Busch

Thank you! That works perfectly