Conditional formatting is a powerful visualization tool, which becomes exponentially more powerful when combined with the flexibility of a PivotTable.

In this tip, we’ll review several ways to customize how conditional formats react to changes in the table layout, and practice some advanced techniques using color scales and data bars.

COMMON USE CASES:

• Using color scales to draw attention to patterns or trends in the data
• Applying formatting rules that “stick” regardless of how the pivot layout changes