|
|
#1
12-05-2014, 11:47 AM
|
|||
|
|||
Conditional Formatting Dates
Cell C2 has a future date in it (1/6/2015).
Range N5:N51 holds various dates. I need to conditionally format the range with a formula like =(=<C2-1097), to format the cells for dates equal to or before 1/6/2012. What would the formula be? 
|
| Tags |
| conditional formatting |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Conditional Formatting/If Statement with Dates | AndrewEnos | Excel | 2 | 07-22-2014 07:34 AM |
| Conditional Formatting - color only dates contained in a range | EC37 | Excel | 1 | 07-08-2014 12:51 PM |
| Conditional Formatting - past due dates | namedujour | Excel | 1 | 06-27-2014 04:16 PM |
 Conditional Formatting with Dates
|
namedujour | Excel | 1 | 02-21-2013 03:42 AM |
| Conditional Formatting Expiration Dates Based on Text in Adjacent Cell | Frogggg | Excel | 1 | 10-25-2011 08:44 PM |
Windows XP 
Office 2003
Threaded Mode