If the formula evaluates to `TRUE` (or any non-zero value), Excel applies the formatting. If it evaluates to `FALSE`, `0`, or an invalid value, no formatting is applied.

Conditional formatting setup We’ll apply a conditional format and a filter to a single column of values. Then, we’ll add a function that updates as you filter the data by the conditional format.

Excel Conditional Formatting already lets you format cells based on the value of those cells or the value of the formulas in those cells (see our conditional formatting tutorial for more details ...

Learn how to highlight dates before today and a specific date with and without using the Today() function in Microsoft Excel.

Regularly update the date sheet for accuracy. Customize the calendar to start weeks on Monday if preferred. Use advanced conditional formatting formulas for additional functionality.

If you’re unfamiliar with Excel’s three ranking functions, consider reading How to calculate rank in an Excel sheet. What is Excel’s RANK.EQ () function?