#1
|
|||
|
|||
Conditional Formatting with Dates
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! |
#2
|
|||
|
|||
Hi namedujour
Assuming your data that you want apply the conditional formatting to, is in column A. Select the column or the range of cells you wish to apply the formatting. Home tab > Conditional Formatting > New rule > Use a formula etc > Use the formula below in the box "Format values where this formula is true: > Apply the required formatting > OK =AND($A1<>"",$A1<DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY()))) |
|
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 |