:: com :: sun :: star :: sheet ::

constants group ConditionOperator2

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
Top of Page