The Grid dashboard item supports the conditional formatting feature that provides the capability to apply formatting to grid cells whose values meet the specified condition. This feature allows you to highlight specific cells or entire rows using a predefined set of rules. To learn more about conditional formatting concepts common for all dashboard items, see the Conditional Formatting topic.
The Grid dashboard item allows you to apply conditional formatting to data items providing data to the following column 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 corresponding to the target dimension/measure values.
To create a new format rule for the Grid's dimension/measure, do one of the following.
Click the Options button next to the required measure/dimension, select Add Format Rule and choose the condition.
Right-click the column header corresponding to the required measure/dimension and select Add Format Rule.
Depending on the selected format condition, the dialog used to create a format rule for Grid contains different settings. For instance, the image below displays the Greater Than dialog corresponding to the Value format condition.
The Apply to row check box allows you to specify whether to apply the formatting to the entire grid row.
To edit format rules for the current Grid dashboard item, use the following options.
All of these actions invoke the Edit Rules dialog containing existing format rules. To learn more, see Conditional Formatting.
The Grid dashboard item allows you to apply conditional formatting to cells. The GridDashboardItem.FormatRules property provides access to a collection of the GridItemFormatRule objects that are used to define formatting settings.
To add a new format rule, create the GridItemFormatRule object and specify the following settings.