Constants |
NONE |
no condition is specified.
|
EQUAL |
value has to be equal to the specified value.
|
NOT_EQUAL |
the value must not be equal to the specified value.
|
GREATER |
the value has to be greater than the specified value.
|
GREATER_EQUAL |
the value has to be greater than or equal to the specified value.
|
LESS |
the value has to be less than the specified value.
|
LESS_EQUAL |
the value has to be less than or equal to the specified value.
|
BETWEEN |
the value has to be between the two specified values.
|
NOT_BETWEEN |
the value has to be outside of the two specified values.
|
FORMULA |
the specified formula has to give a non-zero result.
|
DUPLICATE |
Conditionally format duplicate values
|
NOT_DUPLICATE |
Conditionally format non-duplicate values
|
Constants' Details |
NONE
const long NONE = 0;
- Description
- no condition is specified.
|
|
EQUAL
const long EQUAL = 1;
- Description
- value has to be equal to the specified value.
|
|
NOT_EQUAL
const long NOT_EQUAL = 2;
- Description
- the value must not be equal to the specified value.
|
|
GREATER
const long GREATER = 3;
- Description
- the value has to be greater than the specified value.
|
|
GREATER_EQUAL
const long GREATER_EQUAL = 4;
- Description
- the value has to be greater than or equal to the specified value.
|
|
LESS
const long LESS = 5;
- Description
- the value has to be less than the specified value.
|
|
LESS_EQUAL
const long LESS_EQUAL = 6;
- Description
- the value has to be less than or equal to the specified value.
|
|
BETWEEN
const long BETWEEN = 7;
- Description
- the value has to be between the two specified values.
|
|
NOT_BETWEEN
const long NOT_BETWEEN = 8;
- Description
- the value has to be outside of the two specified values.
|
|
FORMULA
const long FORMULA = 9;
- Description
- the specified formula has to give a non-zero result.
|
|
DUPLICATE
const long DUPLICATE = 10;
- Description
- Conditionally format duplicate values
|
|
NOT_DUPLICATE
const long NOT_DUPLICATE = 11;
- Description
- Conditionally format non-duplicate values
|
|
Copyright © 1995, 2012, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.