Conditional Formatting Dates Less Than 14 Years Ago
 

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. I'm using Excel 2010 on Windows XP.

Thanks so much for any assistance you can provide!

Conditional Formatting Dates Less Than 14 Years Ago
 

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:
=I3DATE(YEAR(TODAY())-14,MONTH(TODAY()),DAY(TODAY()))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Thank you! That works perfectly.