|
|
#2
02-21-2013, 03:42 AM
|
|||
|
|||
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 |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode