To edit a conditional format rule, select the rule and click Edit ().
Click Delete () to delete the selected format rule.
The format rule's menu Condition section contains appearance settings. You can change predefined conditions' settings or define new a new appearance for the applied rule.
Follow the steps below to specify the Value of the format's appearance settings:
Choose a predefined background color or font in the Appearance tab.
Add a predefined icon in the Icons tab.
You can customize predefined colors and values for each Range format rule.
The Grid dashboard item allows you to apply conditional formatting to data items which provide data to the dimension and measurecolumn types.
You can use hidden measures to specify a condition used to apply formatting to visible values. New appearance settings are applied to grid cells that correspond to the target dimension/measure values.
The format rule's Miscellaneous section contains the following properties that are specific to the Grid item:
Enables/ Disables the current format rule.
Applied to Row
Applies the current format rule to a row.
The Pivot dashboard item allows you to use conditional formatting for measures in the Values section and dimensions in the Columns/Rows sections.
You can use hidden measures to specify a condition used to apply formatting to visible values. New appearance settings are applied to data cells that correspond to a row/column intersection. You can set a new intersection of the row and column or use predefined settings.
Note the following specifics:
The dashboard does not calculate conditional formatting in the pivot grid for percentage values on multiple levels. In this case, "All Levels" intersection mode is unavailable.
If you create a new format rule for a dimension from the Columns/Rows section, the corresponding format condition dialog does not contain any Pivot-specific settings.