| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting from Dates | Excel Worksheet Functions | |||
| Conditional Formatting with Dates | Excel Programming | |||
| Conditional formatting dates | Excel Discussion (Misc queries) | |||
| Conditional formatting dates | Excel Discussion (Misc queries) | |||
| How do I subtract dates to get a number in years or years & month | Excel Discussion (Misc queries) | |||
Linear Mode
