You can also use custom formulas to decide whether to apply a specific formatting rule to a range of cells. Excel offers a set of standard conditional formatting options. Applying Conditional Formatting to DatesĬonditional Formatting in Excel allows you to format one or more cells based on the values in those cells.
So in this lesson, we'll look at how to apply the formatting to cells containing all dates in the past, not just those in the last month. These are simple and easy to apply but the problem for our scenario is that there isn't a built-in conditional formatting rule that applies to all dates in the past - the best you can do with the built-in rules is to format cells containing dates that are in the last month. Note that Excel's Conditional Formatting feature includes an option to highlight dates according to a range of pre-configured conditional formatting rules.
You can even use the value of other cells in the worksheet as part of your conditional formatting criteria. It allows you to apply formatting to cells or ranges of cells based on criteria that you can choose. Excel's Conditional Formatting feature is incredibly powerful.