![]() |
|
#1
|
|||
|
|||
|
Conditional formatting gives you the option of formatting cells based on a date occurring "yesterday," "in the last 7 days,"last week" and "last month."
However, I need to create a formula to format cells older than today (yesterday) going back 12 months. How would I do this? Thanks! |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| conditional formatting | otuatail | Excel | 1 | 06-06-2012 05:07 AM |
| Conditional formatting | zanat0s | Excel | 4 | 01-20-2012 03:30 AM |
| Conditional Formatting Expiration Dates Based on Text in Adjacent Cell | Frogggg | Excel | 1 | 10-25-2011 08:44 PM |
Conditional Formatting
|
namedujour | Excel | 3 | 08-25-2011 01:46 PM |
help with conditional formatting
|
Snvlsfoal | Excel | 3 | 07-03-2011 11:55 PM |