Excel also allows applying the said formatting rules on user-defined criteria. For example, suppose we need to highlight the cells with dates that are older than 30 days or 60 days.

TL;DR Key Takeaways : Use Excel’s `TODAY` function and dynamic formulas like `IF` statements to track deadlines and categorize tasks as “On Time,” “Due Soon,” or “Overdue.” ...