Gradient Ranges
Gradient Ranges allow you to use predefined color gradients to apply conditional formatting to different ranges of values. You can also use specific colors to generate custom gradients.
To format values according the required condition, click the measure menu button, select Add Format Rule | Color Ranges and choose the required color gradient.
This invokes the Gradient Ranges 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 Red-Blue gradient.
This dialog allows you to change the following options specific to Gradient Ranges.
Number of ranges allows you to specify the number of ranges used to classify values. Click the Generate Ranges button to generate a new gradient scale according to the specified number of ranges.
To change the specific color in the gradient, click the button next to the required color and select a new color or specify a custom background color. This allows you to create a color gradient based on more than two colors. In this case, the specified colors are marked with an empty square.
To learn how to specify a custom color, see the Specify Appearance Settings paragraph in the Conditional Formatting topic.
The greater or equal sign includes the smallest value in the current interval while the greater sigh excludes the smallest value from the current interval and includes it in the next interval.