Between
|
|
|
Colors all the items representing values that meet the bounding conditions in the selected color. You can specify a value, a calculated range (such as between minimum and average), or an expression. Selecting
Custom Expression displays a dialog where you can provide the expression to evaluate.
|
Boolean expression
|
|
|
Colors the items meeting the condition in the expression.
|
Bottom
|
|
|
Colors the bottom number of items (specified by either the value or the custom expression) in the selected color.
|
Contains
|
|
|
Colors all items matching either the applied value or expression in the specified color.
|
Ends with
|
|
|
Colors all items that end in the specified string in the specified color.
|
Equal to
|
|
|
Colors all items that match the specified value or condition applied from the drop-down list in the selected color. Selecting
Custom Expression displays a dialog where you can provide the expression to evaluate.
|
Greater than
|
|
|
Colors all items with a value greater than the specified value or condition selected from the drop-down list in the selected color. Selecting
Custom Expression displays a dialog where you can provide the expression to evaluate.
|
Greater than or equal to
|
|
|
Colors all items, inclusive of any item matching the specified value or condition selected from the drop-down list in the selected color. Selecting
Custom Expression displays a dialog where you can provide the expression to evaluate.
|
Less than
|
|
|
Colors all items with a value less than the specified value or condition selected from the drop-down list in the selected color. Selecting
Custom Expression displays a dialog where you can provide the expression to evaluate.
|
Less than or equal to
|
|
|
Colors all items, inclusive of any item matching the specified value or condition selected from the drop-down list in the selected color. Selecting
Custom Expression displays a dialog where you can provide the expression to evaluate.
|
Not equal to
|
|
|
Colors all items that do not match the specified value or condition applied from the drop-down list in the selected color. Selecting
Custom Expression displays a dialog where you can provide the expression to evaluate.
|
Starts with
|
|
|
Colors all items that start with the specified string in the specified color.
|
Top
|
|
|
Colors the top number of items (specified by either the value or the custom expression) in the selected color.
|