Conditional formatting not updating 2016

6854933580_2c8b688306_z

Let’s first look at the regular way of applying conditional formatting in a pivot table.

Given that Pivot Tables are so dynamic and the data in the backend can change often, you need to know the right way to use conditional formatting in a pivot table in Excel.The reason, as I mentioned above, is that the conditional formatting has been applied on a fixed range (B5: D14), and it doesn’t get extended to new data in the pivot table.Here are two methods to make sure conditional formatting works even when there is new data in the backend.Add multiple conditions to a rule by selecting Add Condition (AND).I have two tables with conditional formatting, which have been working fine and rendering in the Service fine.We’ve also added several new table and matrix improvements based on the feedback you’ve given us on our User Voice forum.

You must have an account to comment. Please register or login here!