Field Summary | ||
---|---|---|
const int | CELL_VALUE | |
This conditional formatting rule compares a cell value to a formula calculated result, using an operator. | ||
const int | EXPRESSION | |
This conditional formatting rule contains a formula to evaluate. When the formula result is true, the cell is highlighted. | ||
const int | COLOR_SCALE | |
This conditional formatting rule creates a gradated color scale on the cells. | ||
const int | DATA_BAR | |
This conditional formatting rule displays a gradated data bar in the range of cells. | ||
const int | ICON_SET | |
This conditional formatting rule applies icons to cells according to their values. | ||
const int | TOP_10 | |
This conditional formatting rule highlights cells whose values fall in the top N or bottom N bracket, as specified. | ||
const int | UNIQUE_VALUES | |
This conditional formatting rule highlights unique values in the range. | ||
const int | DUPLICATE_VALUES | |
This conditional formatting rule highlights duplicated values. | ||
const int | CONTAINS_TEXT | |
This conditional formatting rule highlights cells containing given text. Equivalent to using the SEARCH() sheet function to determine whether the cell contains the text. | ||
const int | NOT_CONTAINS_TEXT | |
This conditional formatting rule highlights cells that are not blank. Equivalent of using LEN(TRIM()). This means that if the cell contains only characters that TRIM() would remove, then it is considered blank. An empty cell is also considered blank. | ||
const int | BEGINS_WITH | |
This conditional formatting rule highlights cells in the range that begin with the given text. Equivalent to using the LEFT() sheet function and comparing values. | ||
const int | ENDS_WITH | |
This conditional formatting rule highlights cells ending with given text. Equivalent to using the RIGHT() sheet function and comparing values. | ||
const int | CONTAINS_BLANKS | |
This conditional formatting rule highlights cells that are completely blank. Equivalent of using LEN(TRIM()). This means that if the cell contains only characters that TRIM() would remove, then it is considered blank. An empty cell is also considered blank. | ||
const int | NOT_CONTAINS_BLANKS | |
This conditional formatting rule highlights cells that are not blank. Equivalent of using LEN(TRIM()). This means that if the cell contains only characters that TRIM() would remove, then it is considered blank. An empty cell is also considered blank. | ||
const int | CONTAINS_ERRORS | |
This conditional formatting rule highlights cells with formula errors. Equivalent to using ISERROR() sheet function to determine if there is a formula error. | ||
const int | NOT_CONTAINS_ERRORS | |
This conditional formatting rule highlights cells without formula errors. Equivalent to using ISERROR() sheet function to determine if there is a formula error. | ||
const int | TIME_PERIOD | |
This conditional formatting rule highlights cells containing dates in the specified time period. The underlying value of the cell is evaluated, therefore the cell does not need to be formatted as a date to be evaluated. For example, with a cell containing the value 38913 the conditional format shall be applied if the rule requires a value of 7/14/2006. | ||
const int | ABOVE_AVERAGE | |
This conditional formatting rule highlights cells that are above or below the average for all values in the range. |
Field Detail |
---|
CELL_VALUE | |
const int CELL_VALUE |
EXPRESSION | |
const int EXPRESSION |
COLOR_SCALE | |
const int COLOR_SCALE |
DATA_BAR | |
const int DATA_BAR |
ICON_SET | |
const int ICON_SET |
TOP_10 | |
const int TOP_10 |
UNIQUE_VALUES | |
const int UNIQUE_VALUES |
DUPLICATE_VALUES | |
const int DUPLICATE_VALUES |
CONTAINS_TEXT | |
const int CONTAINS_TEXT |
NOT_CONTAINS_TEXT | |
const int NOT_CONTAINS_TEXT |
BEGINS_WITH | |
const int BEGINS_WITH |
ENDS_WITH | |
const int ENDS_WITH |
CONTAINS_BLANKS | |
const int CONTAINS_BLANKS |
NOT_CONTAINS_BLANKS | |
const int NOT_CONTAINS_BLANKS |
CONTAINS_ERRORS | |
const int CONTAINS_ERRORS |
NOT_CONTAINS_ERRORS | |
const int NOT_CONTAINS_ERRORS |
TIME_PERIOD | |
const int TIME_PERIOD |
ABOVE_AVERAGE | |
const int ABOVE_AVERAGE |