| Modifier and Type | Field and Description |
|---|---|
| public static final ConditionType | CELL_VALUE_IS
This conditional formatting rule compares a cell value to a formula calculated result, using an operator |
| public static final ConditionType | COLOR_SCALE
This conditional formatting rule contains a color scale, with the cell background set according to a gradient. |
| public static final ConditionType | DATA_BAR
This conditional formatting rule sets a data bar, with the cell populated with bars based on their values |
| public static final ConditionType | FILTER
This conditional formatting rule that files the values |
| public static final ConditionType | FORMULA
This conditional formatting rule contains a formula to evaluate. |
| public static final ConditionType | ICON_SET
This conditional formatting rule sets a data bar, with the cell populated with bars based on their values |
| public final byte | |
| private static Map | |
| public final String |
| Access | Constructor and Description |
|---|---|
| private |
| Modifier and Type | Method and Description |
|---|---|
| public static ConditionType | |
| public static ConditionType | |
| public String |
| CELL_VALUE_IS | back to summary |
|---|---|
| public static final ConditionType CELL_VALUE_IS This conditional formatting rule compares a cell value to a formula calculated result, using an operator | |
| COLOR_SCALE | back to summary |
|---|---|
| public static final ConditionType COLOR_SCALE This conditional formatting rule contains a color scale, with the cell background set according to a gradient. | |
| DATA_BAR | back to summary |
|---|---|
| public static final ConditionType DATA_BAR This conditional formatting rule sets a data bar, with the cell populated with bars based on their values | |
| FILTER | back to summary |
|---|---|
| public static final ConditionType FILTER This conditional formatting rule that files the values | |
| FORMULA | back to summary |
|---|---|
| public static final ConditionType FORMULA This conditional formatting rule contains a formula to evaluate. When the formula result is true, the cell is highlighted. | |
| ICON_SET | back to summary |
|---|---|
| public static final ConditionType ICON_SET This conditional formatting rule sets a data bar, with the cell populated with bars based on their values | |
| id | back to summary |
|---|---|
| public final byte id | |
| lookup | back to summary |
|---|---|
| private static Map<Integer, ConditionType> lookup | |
| type | back to summary |
|---|---|
| public final String type | |
| ConditionType | back to summary |
|---|---|
| private ConditionType(int id, String type) | |
| forId | back to summary |
|---|---|
| public static ConditionType forId(byte id) | |
| forId | back to summary |
|---|---|
| public static ConditionType forId(int id) | |
| toString | back to summary |
|---|---|
| public String toString() Overrides java. Doc from java. Returns a string representation of the object.
Satisfying this method's contract implies a non-
| |