Cells Formats and Conditional Formating in Pivot View

The format option allows configuring such Cells Formats as value, text-align, decimal places and etc. 

Open

Open

Also, in the Format drop-down list, you can select the conditional formatting.

Click the “plus” button to add a condition.

In the first raw choose the calculated value, option for condition (less than, greater then, equal to, etc.) and enter the number.

In the second raw you can set the font and font size, text color or highlighting the cell. That will work if the condition in the first raw is true.

As a result, all cells where the number is more than 40 will be highlighted with the color you’ve chosen.