Formatting not updating

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.Sometimes, when you update an Index Field, your Page Headers can change, or disappear; sometimes your page formatting may change.These effects can happen when you have an Index formatted with an explicit number of columns and you have different formatting of the body of the Document before and after the Index.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.When you apply conditional formatting to a block of cells in the pivot table, the formatting rule is applied to those cells only. I’m a big fan of Excel’s conditional formatting, and often use it to highlight cells on a worksheet.

formatting not updating-65formatting not updating-89

But this week I ran into a conditional formatting crisis, and had to start from scratch.Add multiple conditions to a rule by selecting Add Condition (AND).Watch this video to see the steps for applying conditional formatting to pivot tables cells.Before going any further, it is worth pointing out that the behaviour is exactly the same when you delete an entire Section.In this case, quite reasonably, the Section following it remains just as it was before.