LinkBack URL
About LinkBacks
I would like to apply conditional formatting for specific columns where boxes in that column are highlighted when the date is at least 1 year old. What formula do I use for this, and how?
I would like to apply conditional formatting for specific columns where boxes in that column are highlighted when the date is at least 1 year old. What formula do I use for this, and how?
Let's assume that your range is A2:A25 and the date from today is greater than one your
use this formula
=DATEDIF($A2:$A$25,TODAY(),"D")>=365
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
So if the date is different in each box in the column, I have to apply a different formula with the date changed in each one? For example, if the box is N4 and the date is 1/16/14, what would the formula be?
Thank you!!
The formula evaluates how many days between today and the earlier date and if the number of days is greater than 365 the formula will return 'TRUE' if not, 'FALSE'. One formula will cover the entire range.Originally Posted by mhaness
Ok, I did it! Thank you so much.
You're welcome. Don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks