You can set Excel up to use today’s date (or any date), to identify past due dates and change the color of the past due text to a different color. This process is showing on Excel 2016 but works on 2007 and all new versions.