Use Microsoft Excel's TODAY() function in simple expressions to highlight the current date and past and future dates.

You can change the date & time format in Google Sheets & Excel Online using this guide. Use different date & time formats in spreadsheets.

The ramifications of missing a due date can range from simply adjusting the date to getting fired. Don't take chances with deadlines when a simple conditional format can remind you.

Excel's conditional formatting lets you formats cells based on the value of those cells or their formulas. Learn the basics of this amazing feature.

The problem is that the minimum bounds are represented by a number, and the dates here are using the Short Date format. Luckily, Excel allows us to easily convert dates into their numerical values.