ig.excel.FormatConditionType
Dependencies
-
average
- Type:
- ig.excel.FormatConditionType
- Default:
- 11
Cells with values which are greater than or less than the average value for the associated region are formatted.
-
blanks
- Type:
- ig.excel.FormatConditionType
- Default:
- 9
Cells with no value are formatted. Note that foreground-related properties such as font colors are not applicable.
-
cellValue
- Type:
- ig.excel.FormatConditionType
- Default:
- 0
The format is based on the cell's value, which is evaluated against one or more conditions to determine whether the value meets a particular criteria.
-
colorScale
- Type:
- ig.excel.FormatConditionType
- Default:
- 2
Represents a conditional formatting rule which applies gradations to cell colors to indicate relative differences in the values of cells which belong to the associated range.
-
dataBar
- Type:
- ig.excel.FormatConditionType
- Default:
- 3
Represents a conditional formatting rule which renders a color bar inside the cell to indicate relative differences in the values of cells which belong to the associated range.
-
duplicateValues
- Type:
- ig.excel.FormatConditionType
- Default:
- 7
Cells with values which are duplicated (non-unique) across the associated range are formatted.
-
errors
- Type:
- ig.excel.FormatConditionType
- Default:
- 13
The format is applied to cells which contain an error.
-
expression
- Type:
- ig.excel.FormatConditionType
- Default:
- 1
The format is determined by evaluating a formula.
-
iconSets
- Type:
- ig.excel.FormatConditionType
- Default:
- 5
Represents a conditional formatting rule which displays an icon inside the cell which indicates the cell's value as relative to the highest and lowest value in the associated range.
-
noBlanks
- Type:
- ig.excel.FormatConditionType
- Default:
- 12
Cells with a non-empty value are formatted.
-
noErrors
- Type:
- ig.excel.FormatConditionType
- Default:
- 14
The format is applied to cells which do not contain an error.
-
rank
- Type:
- ig.excel.FormatConditionType
- Default:
- 4
Cells with the top/bottom n values are formatted, where n represents a numeric, percentage, or percentile ranking. For example, this type can be used to to enable a 'top ten' condition.
-
textString
- Type:
- ig.excel.FormatConditionType
- Default:
- 8
The format is determined by whether the cell's value matches a literal string value.
-
timePeriod
- Type:
- ig.excel.FormatConditionType
- Default:
- 10
The format is determined by whether a cell's date value falls within a given period of time.
-
uniqueValues
- Type:
- ig.excel.FormatConditionType
- Default:
- 6
Cells with values which are unique across the associated range are formatted.