Learn how to add a highlight to expose groups in your Microsoft Excel data using a helper column and Excel’s conditional formatting feature.

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

The IF statement is a popular logical function in Excel. The SWITCH statement is less known, but you can use it instead of the IF statement in some scenarios. Let's explore these functions and ...