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

In Microsoft Excel, you can create relationships between two tables based on the matching data within the table, even when the tables are from different sources.

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

Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

In this story, we’ll get you up and running with tables in Excel, from creating and formatting them to performing calculations on their data.

Struggling with disorganized data in Excel can be incredibly frustrating. You have all the information you need, but without connections between tables, it’s like trying to solve a puzzle with ...