Conditional formatting in the pivot grid allows me to customize the font style, text representation, font color, and fill color based on certain conditions.
The conditional formatting option is available in the Formatting section of the “Properties” column. Enable Advanced Setting, and the formatting dialog will open.
The conditional formatting dialog even allows me to add a condition based on a completely different field than the one already configured. I can also choose various condition types and formatting options as shown in the following image.
Now, I would like to highlight the “UnitPrice” which is greater than 1000 with respect to “ShipCity.” I added the condition as you can see below.
Now, my widget highlights the value based on this condition.