Question: In Microsoft Excel 2010, is there a way to automatically highlight past due dates bases on a range of days?
For example, I have a column with a lists of dates depicting when milestones are due. I would like Excel to highlight dates using conditional formatting based on how long they are overdue. I would like to highlight milestones over 60 to 90 days overdue in yellow, Actions 90 to 120 days overdue in orange and Actions over 120 days overdue in red. Based on todays date.
I have created the following formula for the Actions over 120 days overdue in red:
=AND(F1<>"",F1<TODAY()-121)
It works fine.
I just cant get the range to work properly. i.e. milestones over 60 to 90 days overdue or Actions 90 to 120 days overdue . This is the formula that I was working on and cant get to work.
=AND(F1-TODAY()>=-60,F1-TODAY()<=-90)
=AND(F1<>"",F1<TODAY()<=-120,F1<>"",F1<TODAY()>=-90)
Any assistance is greatly appreciated.
Bookmarks