You don’t need a complex expression to add conditional formatting to a filtered PivotTable in Microsoft Excel.

Turn raw data into actionable insights with Excel 365’s conditional formatting. Learn to create dynamic visuals with ease in this guide.

TODAY () is a DATE function in Excel that returns the current date. The whole formula says that if a date in the Due Date column is less than today, we want to do some conditional formatting.

Excel for the web now supports conditional formatting, and the interface is easier to use than the desktop edition. Susan Harkins shows you how to use it.

How to use Excel's new Cube-based functions and conversion tools to convert a PivotTable to a formula-based report.