Conditional formatting not updating automatically
If you are applying conditional formatting to a pivot table, you might need to adjust the settings, to ensure that the correct cells are formatted, after the pivot table changes.
In a pivot table with a simple layout, you can select a group of cells, and apply a conditional formatting rule.
La=function();function bj(a) C(bj,$i);bj.prototype[th]=! 0;r=bj.prototype;r.listen=function(a,b,c,d);r.ag=function();r.
$/;function Si(a) ;function Ti(a) function Ui(a) function Yi(a) r.uc=function();window.sc_init Selects=function();function $i(a) ;function aj(a) C(aj,$i);aj.prototype. a.ka&&"undefined"==typeof XMLHttp Request&&"undefined"!
The Grand Total amounts won't be included, because they would skew the average.
To apply conditional formatting: The cells with above average values are highlighted.
The new data appears in the pivot table, but it does not have the conditional formatting rule applied, because it is outside of the original block of cells.from the top menu: Google Sheets will default to applying the “Cell is not empty” rule, but we don’t want this here.