If your subtotaling rows are lost in a sea of worksheet data, use this simple conditional formatting technique to make those rows easy to spot. Excel’s Subtotal feature is a great way to quickly ...

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