| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Conditional Formatting ... Today() & More
Excel 2000 ... What I have
Col T ... contains values ... 0 & 1 Col AA ... contains dates ... mm/dd/yy In Col AR I wish Conditional Formatting Formula for when condition is: Col T = 1 Col AA = date older than 3 years from Today. Thanks ... Kha |
|
#2
|
|||
|
|||
|
one way:
CF1: Formula is =AND(T1=1, DATEDIF(AA1+1,TODAY(),"y")=3) In article , "Ken" wrote: Excel 2000 ... What I have Col T ... contains values ... 0 & 1 Col AA ... contains dates ... mm/dd/yy In Col AR I wish Conditional Formatting Formula for when condition is: Col T = 1 Col AA = date older than 3 years from Today. Thanks ... Kha |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting in Excel Help Please..... | Excel Discussion (Misc queries) | |||
| conditional formatting conflict? | Excel Worksheet Functions | |||
| Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
| Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
