Enum eExcelPivotTableConditionalFormattingRuleType¶
Namespace: OfficeOpenXml.ConditionalFormatting
Assembly: EPPlus.dll
Conditional formatting rule types valid for pivot tables.
Fields¶
AboveAverage = 0
Highlights cells that are above the average for all values in the range.
AboveAverage Excel CF Rule Type
AboveOrEqualAverage = 1
Highlights cells that are above or equal to the average for all values in the range.
AboveAverage Excel CF Rule Type
BelowAverage = 2
Highlights cells that are below the average for all values in the range.
AboveAverage Excel CF Rule Type
BelowOrEqualAverage = 3
Highlights cells that are below or equal to the average for all values in the range.
AboveAverage Excel CF Rule Type
AboveStdDev = 4
Highlights cells that are above the standard deviation for all values in the range.
BelowStdDev = 5
Highlights cells that are below the standard deviation for all values in the range.
AboveAverage Excel CF Rule Type
Bottom = 6
Highlights cells whose values fall in the bottom N bracket as specified.
Top10 Excel CF Rule Type
BottomPercent = 7
Highlights cells whose values fall in the bottom N percent as specified.
Top10 Excel CF Rule Type
Top = 8
Highlights cells whose values fall in the top N bracket as specified.
Top10 Excel CF Rule Type
TopPercent = 9
Highlights cells whose values fall in the top N percent as specified.
Top10 Excel CF Rule Type
Between = 21
Highlights cells in the range between the given two formulas.
CellIs Excel CF Rule Type
ContainsBlanks = 22
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.
ContainsErrors = 23
Highlights cells with formula errors.
Equivalent to using ISERROR() sheet function to determine if there is a formula error.
Equal = 27
Highlights cells equal to the given formula.
CellIs Excel CF Rule Type
Expression = 28
This rule contains a formula to evaluate. When the formula result is true, the cell is highlighted.
Expression Excel CF Rule Type
GreaterThan = 29
Highlights cells greater than the given formula.
CellIs Excel CF Rule Type
GreaterThanOrEqual = 30
Highlights cells greater than or equal the given formula.
CellIs Excel CF Rule Type
LessThan = 31
Highlights cells less than the given formula.
CellIs Excel CF Rule Type
LessThanOrEqual = 32
Highlights cells less than or equal the given formula.
CellIs Excel CF Rule Type
NotBetween = 33
Highlights cells outside the range in given two formulas.
CellIs Excel CF Rule Type
NotContainsBlanks = 35
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.
NotContainsErrors = 36
Highlights cells without formula errors.
Equivalent to using ISERROR() sheet function to determine if there is a formula error.
NotEqual = 38
.
CellIs Excel CF Rule Type
ThreeColorScale = 40
Three Color Scale (Low, Middle and High Color Scale)
ColorScale Excel CF Rule Type
TwoColorScale = 41
Two Color Scale (Low and High Color Scale)
ColorScale Excel CF Rule Type
ThreeIconSet = 42
This conditional formatting rule applies a 3 set icons to cells according to their values.
IconSet Excel CF Rule Type
FourIconSet = 43
This conditional formatting rule applies a 4 set icons to cells according to their values.
IconSet Excel CF Rule Type
FiveIconSet = 44
This conditional formatting rule applies a 5 set icons to cells according to their values.
IconSet Excel CF Rule Type
DataBar = 45
This conditional formatting rule displays a gradated data bar in the range of cells.
DataBar Excel CF Rule Type