Instantly Highlight Old Dates: Conditional Formatting for Rows Older Than 30 Days

Manually tracking and identifying dates that are past a certain threshold in large datasets can be incredibly time-consuming and error-prone. This common Excel challenge, especially for tasks like monitoring project deadlines, invoice due dates, or aging inventory, calls for an automated solution. Instead of sifting through rows, you can leverage Excel's conditional formatting with a dynamic formula to visually alert you to dates that are more than 30 days old relative to the current day.

This powerful formula, when applied correctly, ensures that any row containing a date in Column C that is 30 days or more in the past will automatically change its formatting. The TODAY() function dynamically adjusts to the current date, meaning your highlighting will always be up-to-date without manual intervention. The AND function is crucial here, combining two conditions: checking that the cell is not blank ($C2<>"") and that the date in Column C is indeed older than 30 days from today ($C2<TODAY()-30). Remember to apply this formula to your desired range (e.g., A2:Z100) and ensure the column reference ($C2) is absolute to the column but relative to the row.

By implementing this conditional formatting rule, you transform your static spreadsheets into dynamic, visually intelligent dashboards. Gain immediate insight into outdated information, flag items needing attention, and significantly improve your data management efficiency. For variations, like highlighting dates within the next 7 days or based on another cell's value, simply describe your logic in our tool to get your custom Excel formula instantly.