Operator |
The operator used when evaluating values in cells, such
as greater than or
between. For example, to style
cells with a value less than 5, select lower
than and specify a Value
1 value of 5. |
Value 1 |
The number to evaluate cell values against. When the
Operator value is
between, enter the lower value in
the Value 1 field. Note: When creating
rules based on a duration value, specify the duration in
seconds. |
Value 2 |
The maximum value a cell can contain to match this rule.
This field only appears when the
Operator value is
between. |
Font color |
The font color to apply to cells that match this
rule. |
Background color |
The background color to apply to cells that match this
rule. |
Rule order |
A numerical value that determines the order in which
rules apply. Rules with a higher rule order apply later and
override lower-order rules. For example, one rule matches
cells with a value greater than 140, and another rule
matches cells with a value less than 150. The rule with
the higher order applies to cells with values from 141
through 149. |