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)
