Microsoft office software contains an Excel application that has an excellent tool called Conditional formatting: this allows you to apply formats to a cell or set of cells. You can highlight due or overdue dates using this feature by applying a formula. To conditionally format dates in MS Excel, MS office software introduced many short cuts. Click conditional formatting from the menu by selecting some cells, choose Highlight cells rules and select a date. You can format the dates quickly in your data using this feature meeting certain criteria. In MS Excel you can also choose colors to make your spreadsheet easier to read. Have a look at the article below to get some concrete examples on how to apply conditional formatting rules.