View Single Post
  #1   Report Post  
rsexcel rsexcel is offline
Junior Member
 
Posts: 3
Default 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!