ExcelBanter - Conditional Formatting ... Today() & More

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Conditional Formatting ... Today() & More (https://www.excelbanter.com/excel-worksheet-functions/12319-conditional-formatting-today-more.html)

Ken

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

JE McGimpsey

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

All times are GMT +1. The time now is 01:24 AM.