Dates are affected by your regional settings and date / time settings in your Control Panel on your device.įor example, if your regional settings are set to U.S., dates are typically entered as mm/dd/yy (month / day / year) unless the date / time settings have been changed. Recommended article: How to Delete Blank Rows in Excel (5 Easy Ways with Shortcuts)ĭo you want to learn more about Excel? Check out our virtual classroom or in-person Excel courses >ĭates must be entered or returned as valid dates in Excel in order to apply conditional formatting.

Create a conditional formatting rule using a formula.

Create a conditional formatting rule based on cell contents.

In this article, we'll review 3 ways to highlight dates before today using conditional formatting: When you apply conditional formatting, you can apply more than one rule to a range of cells. This type of formatting is helpful if you want to highlight past due dates such as invoices that are 30, 60 or 90 days overdue.

In a worksheet, you can use conditional formatting to highlight selected cells by filling them with a color based on rules or conditions. You can use conditional formatting in Excel to highlight cells containing dates before today or within a date range before the current date. Highlight Dates Before Today or Within a Date Range in Excel Using Conditional Formattingīy Avantix Learning Team | Updated November 21, 2021Īpplies to: Microsoft ® Excel ® 2010, 2013, 2016, 2019 and 365 (Windows)

Format date cells in excel not working