Using pivot table total and conditional formatting with a gradient


It seems that if you use both the pivot table total on column level setting and conditional formatting using a gradient setting, then the total values wont display at all. For the normal conditional formatting there is a button with “apply to: totals / subtotals / value” but there is no such setting when using a gradient.

Perhaps it is intentional or a bug?


Hi @DanielJansson, At AWS, our roadmap is primarily driven by our customers. Your feedback helps us build a better service. I have tagged this as a feature request.