Conditional styles give you freedom to change a pivot table appearance to make the data more readable. For example, you can highlight values of some field that are greater than 100 with the red color, and values of another field that meet some other condition with the blue color, the difference between data in a pivot table will be clear at a glance.
Besides setting a background color for some cells, you can select an image as a background, change a font and its color, specify a condition to apply only for some values in a required field, etc.
Let’s examine conditional styles benefits by the following example:
There is the list of films and their rental payments grouped by month and year. It is required to quickly identify which films bring the expected revenue, the sum of their rental payments meet the planned monthly range of 20-40 and which films are in less demand, the sum of their rental payments are less than 10.
Conditional styles in use:
In the Appearance section click the BackColor field and select LightBlue. Now, the first condition is ready. Click the Add Condition icon to create another condition for the films which have the sum of payment amounts less than 10.
Click OK to apply the conditional styles to the pivot table. The data will look like the following: