Enum eExcelConditionalFormattingRuleType¶
Namespace: OfficeOpenXml.ConditionalFormatting
Assembly: EPPlus.dll
Enum for Conditional Format Type ST_CfType ยง18.18.12. With some changes.
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
Last7Days = 10
Highlights cells containing dates in the last 7 days.
TimePeriod Excel CF Rule Type
LastMonth = 11
Highlights cells containing dates in the last month.
TimePeriod Excel CF Rule Type
LastWeek = 12
Highlights cells containing dates in the last week.
TimePeriod Excel CF Rule Type
NextMonth = 13
Highlights cells containing dates in the next month.
TimePeriod Excel CF Rule Type
NextWeek = 14
Highlights cells containing dates in the next week.
TimePeriod Excel CF Rule Type
ThisMonth = 15
Highlights cells containing dates in this month.
TimePeriod Excel CF Rule Type
ThisWeek = 16
Highlights cells containing dates in this week.
TimePeriod Excel CF Rule Type
Today = 17
Highlights cells containing todays date.
TimePeriod Excel CF Rule Type
Tomorrow = 18
Highlights cells containing tomorrows date.
TimePeriod Excel CF Rule Type
Yesterday = 19
Highlights cells containing yesterdays date.
TimePeriod Excel CF Rule Type
BeginsWith = 20
Highlights cells in the range that begin with the given text.
Equivalent to using the LEFT() sheet function and comparing values.
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.
ContainsText = 24
Highlights cells in the range that begin with the given text.
Equivalent to using the LEFT() sheet function and comparing values.
DuplicateValues = 25
Highlights duplicated values.
DuplicateValues Excel CF Rule Type
EndsWith = 26
Highlights cells ending with the given text.
Equivalent to using the RIGHT() sheet function and comparing values.
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
NotContains = 34
Highlights cells that does not contains the given formula.
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.
NotContainsText = 37
Highlights cells that do not contain the given text.
Equivalent to using the SEARCH() sheet function.
NotEqual = 38
.
CellIs Excel CF Rule Type
UniqueValues = 39
Highlights unique values in the range.
UniqueValues 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