I expect my code probably won't make much sense to very many people, but I still wanted to post it just in case somebody might find a use in modifying it for something else. It's written in VBA in ...
How-To Geek on MSN
Conditional formatting breaks in Excel PivotTables—until you turn on this hidden setting
PivotTable-aware conditional formatting ties rules to fields, so visuals persist even when you refresh, filter, or change layout.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results