Configure and Manage Conditional Formatting of Tables and Pivot Grids

Conditional formatting helps you highlight data in Table and Pivot Grid views by using rules that emphasize values based on criteria. Use formatting styles such as font color, background color, and font style to identify trends, outliers, and key metrics.

Limitations

The following limitations apply:

• Only Table and Pivot Grid views are supported.
• You can apply a total of 30 rules, with five rules per column and five conditions per rule.
• If multiple rules apply to the same cell or element, the system uses the established conditional formatting precedence order.
• Rules that referenced removed columns or fields are ignored.
• Rule names must be unique, with at least one condition and one style per rule.
• Before you remove the column, delete a column's rules.
• PDF exports retains formatting.

To configure and manage conditional formatting of tables and pivot grids in a project or shell:

1. Sign in to Unifier with project/shell user credentials.
2. Select the specific project/shell tab, and switch to User mode.
   For example, select a tab called Vision Corporation.
3. In the left Navigator, select Visualizations.

   or

   If configured, access the Visualizations log from a business process log as follows:

   1. In the left Navigator, select Logs, and then select a specific business process, such as Contracts.
   2. From the Visualization list, just below the User mode indicator, select a visualization.
4. In the Visualizations log (right pane), select any of the following actions:
   • Select Create to add a new visualization in the project/shell.
   • Select a visualization in the log, and then select Edit.
5. On the Edit page, select a Pivot Grid or Table in the visualization layout.
6. From the More Actions menu, select Conditional Formatting.
7. In the Conditional Formatting drawer, select Add to create a new rule by specifying a maximum of five conditions:
   1. In the Rule Name field, enter a unique rule name, a maximum length of 60 characters.
   2. From the Column list, select a data element on which the rule will be applied.

      For Tables, select a data field for a column.

      For Pivot Grids, select a data field for a column, row, or value.

   3. In the Condition Builder block, to define at least one condition:
      1. Select Any (to apply any one condition) or All (to apply all conditions), and then select Add (+).
      2. From the Data Element list, select a data element to create a condition.
      3. From the Condition list, select a condition to apply on the selected data element such as Contains, Does not contain, Is empty, or Is not empty.
      4. From the Value list, enter a value that needs to be satisfied by the condition.
      5. To add another condition, repeat the previous steps.
      6. To discard a specific condition or a group of conditions, select Delete .
      7. Select any or all formatting options such as bold, italic, underline, strikethrough, text color, or background color.
      8. Preview and adjust the formatting as required, and then perform any of the following actions:
         • To add more rules, select Create and Close or Create and Next. Rules created for the same data element selected in the Column list are grouped together.
         • To discard the condition, select Cancel.

   When multiple rules are specified, the Conditional Formatting drawer groups the rules by Column or Row.

8. After creating rules, perform any of the following actions from the Actions menu :
   • To edit a rule, select Edit.
   • To discard the rule, select Remove.
   • To reorder the rules, select Drag .