How to use Conditional Formatting to highlight a cell based from that cell's date?
I'm having issues coming up with a way to have the cells highlight after a specific amount of days. I.E. Customer submits an application on 2/15/2018. I would like that cell to highlight after it has been 20 days, and then again at 30 days.
When I use the TODAY() > 30 formula, it highlights the entire column. I am fairly new to conditional formatting, could anyone give me some assistance?
That won't work. Try
=AND(TODAY()-A2>30,A2<>"")
where a2 contains the date you are checking. here is a two-tone example in A2 to A20 of the attached sheet.
Last edited by Glenn Kennedy; 03-27-2018 at 11:41 AM.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks