Conditional formatting lets you transform static Excel spreadsheets into dynamic canvases of information. You can set different rules with formatting conditions, and the system highlights cells ...

In the resulting submenu, choose either cell or font color. Filtering by the conditional format was easy, but the SUM () function doesn’t reflect the data that you see.

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