PIVOTBY is great for analysis, but PivotTables still have the edge when formatting needs to adapt to data changes.

PivotTable-aware conditional formatting ties rules to fields, so visuals persist even when you refresh, filter, or change layout.

Imagine this: you’re managing a sprawling Excel spreadsheet with thousands of rows of data. You need to identify high-priority tasks, flag anomalies, or categorize entries based on specific rules.