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

I feel like I'm on the cusp of figuring something out, but I'm not quite there. Got a spreadsheet with drop-down for eleven options. Two categories should be red, two green, and seven yellow. I can do ...