Hello, I am having an issue with the conditional formatting of totals/subtotals in a pivot table.
I have both ‘Values’, ‘Totals’ and ‘Subtotals’ all selected in the conditional formatting field, however am still unable to get the pivottable totals to be conditional formatted.
Any ideas?
Try clear all the formatting and re add them.
Hi @cmagowan
It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.
If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.
Thank you!
Apologises for the slow reply!
Unfortunately removing the formatting and re adding did not solve the issue.
It looks like the issue is that my total is ‘sum’, not the ‘default’ - is there a workaround for this?
