Highlighting cells in a pivot table based on exceeding a limit value, but limits are different for each category.

[TheBrandonMaxwell]

On a pivot table I have categories of inventory and each one has a quantity on the sum.
I want to highlight the quantity if it exceeds a limit but the limits are different.

So if the sum of catalog codes for the category 'core balloon devices' exceeds 10, i want to be highlighted.
But if the sum of 'other device' exceeds 5 it ALSO needs to be highlighted.

The issue is that with a pivot, if I use conditional formatting and someone filters different info, the condition is lost.
Thanks in advance

 

[Jerry Sullivan]

Welcome to MrExcel,

When you create a new formatting rule with a PivotTable cell selected, in the dialog window you can chose whether to apply that by cell address or by the selected field(s).

If you're finding that the CF disappears during some filtering operations, you've probably accepted the default method (by cell address). If you apply based on fields then the cells affected by CF will be adjusted based on PivotTable operations.