Use these dialogs to define or edit an icon rule.
To reach the Add/Edit Rule dialog:
In the Icon Settings dialog, go to the Icons page.
Click on the Add Rule... button to add a rule. To edit an existing rule, double-click on the rule of interest in the list.
Option |
Description |
Rule
type |
Specifies which rule type to add. See below for descriptions of all available rule types. |
Value |
Defines the value or values the rule should apply to. The available options depend on the rule type selected. See Details on Point/Value Menu for descriptions of all the options in this menu. |
Color |
Specifies the color of the icon. |
Shape |
Specifies the shape of the icon. |
Available rule types:
Rule Type |
Description |
Top |
Adds an icon of the selected appearance to the rows of the top number of items. Specify the number of items to affect in the Value field. Note: In some cases more than the defined number of items may be affected. For example, if the rule states that the top three items should be indicated using a yellow star, and four items represent the highest value, then all four of these items will get the yellow star. |
Bottom |
Adds an icon of the selected appearance to the rows of the bottom number of items. Specify the number of items to affect in the Value field. Note: In some cases more than the defined number of items may be affected. For example, if the rule states that the bottom three items should be indicated using a red star, and four items represent the lowest value, then all four of these items will get the red star. |
Between |
Adds an icon of the selected appearance to all the items representing values between the two specified values. Specify the values in the two Value fields. |
Equal
to |
Adds an icon of the selected appearance to all the items representing values that are equal to the specified value. |
Not
equal to |
Adds an icon of the selected appearance to all the items representing values that are not equal to the specified value. |
Greater
than |
Adds an icon of the selected appearance to all the items representing values greater than the specified value. |
Greater
than or equal to |
Adds an icon of the selected appearance to all the items representing values greater than or equal to the specified value. |
Less
than |
Adds an icon of the selected appearance to all the items representing values less than the specified value. |
Less
than or equal to |
Adds an icon of the selected appearance to all the items representing values less than or equal to the specified value. |
Boolean
expression |
Lets you define a boolean expression. All the items for which the expression is true will get the an icon of the selected appearance. See To add a boolean expression as a rule for a description. To learn more about custom expressions in general, see Custom Expressions Introduction. |
See also: