If I want to know if a something has not met the due date set in my
spreadsheet, can Excel send me an alert in some way?

Or can the cell become flagged when the date is not met so it can be easily
detected?