Hey all,
I have a pivot table set up, where some of my fields for the ‘Rows’ field well, are collapsed. I want to apply conditional formatting to the collapsed totals, using the ‘Gradient’ option. However, the ‘Apply To’ option for conditional formatting (see screenshot), which is available when using ‘Solid’, IS NOT available when using ‘Gradient’.
Is there no way to apply conditional formatting to totals, when using ‘Gradient’ conditional formatting?
