Conditional Formatting ... Today() & More

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditionally Format Particular Dates 1
Date Format 2
Conditional Multiply and Sum 2
Month (MMM) from date (dd/mmm/yy) 1
Conditional Formatting 3
Max Value, Sum Product, Between Date Range 3
Format individual coloumn cell with corresponding coloum cell resu 1
Search between dates & return other column 8

Back
Top