Color Ranges

Color Ranges allow you to use predefined sets of colors to apply conditional formatting to different ranges of values. You can also use custom appearance settings for specific ranges.

Create a Format Rule

To format values according to the required condition, click the data item menu button, select Add Format Rule | Color Ranges and choose the required color set.

ColorRanges_Menu

This invokes the Range Set dialog containing the set of value ranges and corresponding appearance settings. The Grid dashboard item on the right displays the default formatting applied using the predefined set of 3 colors.

ColorRangeSetDialog

This dialog allows you to change the following options specific to Color Ranges.

  • The Format Style combo box allows you to change the color set used to apply formatting.
  • The Use % ranges check box specifies whether the percent or absolute scale is used to generate ranges.

    Note

    Note that this option is not available for date-time dimensions.

  • To change the appearance settings applied to values corresponding to the specified range, click the button next to the required color and select a new color or specify custom appearance settings. To learn how to specify custom settings, see the Specify Appearance Settings paragraph in the Conditional Formatting topic.

    ColorRangeSetDialog_ChangeAppearance

    Select No Style to disable the indication for the required range.

  • You can change range boundaries by specifying the required values.

    ColorRangeSetDialog_ChangeRangeStop

    Note

    Note that a new value should fall into a range between corresponding values of the previous and next range.

  • To change the comparison logic for the required range, click the comparison sign and select the required option.

    ColorRangeSetDialog_ChangeComparisonLogic

    The greater or equal sign includes the smallest value for the current interval, while the greater sign excludes the smallest value from the current interval and includes it in the next interval.

  • Use the Add and Delete buttons to add new ranges or delete the selected range respectively.
  • Use the Reverse button to reverse the order of style settings corresponding to different ranges.

Create a Format Rule in Code

Range conditions (Icon Ranges and Color Ranges) allow you to apply formatting using a predefined set of value ranges and corresponding style settings. You can use a predefined set of colors/icons to apply formatting, or use custom ranges and corresponding icons/colors.

  1. To use a predefined set of colors/icons, pass the required FormatConditionRangeSetPredefinedType enumeration value to the FormatConditionRangeSet constructor and assign the resulting FormatConditionRangeSet object to the DashboardItemFormatRule.Condition property.
  2. To use a predefined set of colors/icons and custom range boundaries, do the following.

  3. To use custom range boundaries and the required style specified for each range, do the following.

Assign the resulting FormatConditionRangeSet object to the DashboardItemFormatRule.Condition property.