1. Home
  2. help
  3. How to Create a Pivot Grid Widget
  4. Conditional Formatting in the Pivot Grid

Conditional Formatting in the Pivot Grid

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.

Advanced formatting

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.

Conditional formatting dialog-pivot grid

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.

Added condition for pivot grid

Now, my widget highlights the value based on this condition.

Conditional formatting result in pivot grid

Was this article helpful to you? Yes 1 No