Junior Member

Posts: 3

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!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional formatting from Dates	DavidM	Excel Worksheet Functions	3	June 11th 09 05:00 PM
Conditional Formatting with Dates	jstegall	Excel Programming	0	November 28th 07 06:39 PM
Conditional formatting dates	Contracto	Excel Discussion (Misc queries)	2	April 10th 07 07:52 AM
Conditional formatting dates	Joe	Excel Discussion (Misc queries)	2	January 17th 07 02:28 PM
How do I subtract dates to get a number in years or years & month	jude	Excel Discussion (Misc queries)	2	August 25th 06 08:02 PM

All times are GMT +1. The time now is 09:44 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us