Enum eExcelConditionalFormattingRuleType

Namespace

OfficeOpenXml.ConditionalFormatting

Assembly

EPPlus.dll

Enum for Conditional Format Type ST_CfType §18.18.12. With some changes.

public enum eExcelConditionalFormattingRuleType

Fields

AboveAverage = 0

Highlights cells that are above the average for all values in the range.

AboveOrEqualAverage = 1

Highlights cells that are above or equal to the average for all values in the range.

AboveStdDev = 4

Highlights cells that are above the standard deviation for all values in the range. AboveAverage Excel CF Rule Type

BeginsWith = 20

Highlights cells in the range that begin with the given text.

BelowAverage = 2

Highlights cells that are below the average for all values in the range.

BelowOrEqualAverage = 3

Highlights cells that are below or equal to the average for all values in the range.

BelowStdDev = 5

Highlights cells that are below the standard deviation for all values in the range.

Between = 21

Highlights cells in the range between the given two formulas.

Bottom = 6

Highlights cells whose values fall in the bottom N bracket as specified.

BottomPercent = 7

Highlights cells whose values fall in the bottom N percent as specified.

ContainsBlanks = 22

Highlights cells that are completely blank.

ContainsErrors = 23

Highlights cells with formula errors.

ContainsText = 24

Highlights cells in the range that begin with the given text.

DataBar = 45

This conditional formatting rule displays a gradated data bar in the range of cells.

DuplicateValues = 25

Highlights duplicated values.

EndsWith = 26

Highlights cells ending with the given text.

Equal = 27

Highlights cells equal to the given formula.

Expression = 28

This rule contains a formula to evaluate. When the formula result is true, the cell is highlighted.

FiveIconSet = 44

This conditional formatting rule applies a 5 set icons to cells according to their values.

FourIconSet = 43

This conditional formatting rule applies a 4 set icons to cells according to their values.

GreaterThan = 29

Highlights cells greater than the given formula.

GreaterThanOrEqual = 30

Highlights cells greater than or equal the given formula.

Last7Days = 10

Highlights cells containing dates in the last 7 days.

LastMonth = 11

Highlights cells containing dates in the last month.

LastWeek = 12

Highlights cells containing dates in the last week.

LessThan = 31

Highlights cells less than the given formula.

LessThanOrEqual = 32

Highlights cells less than or equal the given formula.

NextMonth = 13

Highlights cells containing dates in the next month.

NextWeek = 14

Highlights cells containing dates in the next week.

NotBetween = 33

Highlights cells outside the range in given two formulas.

NotContains = 34

Highlights cells that does not contains the given formula.

NotContainsBlanks = 35

Highlights cells that are not blank.

NotContainsErrors = 36

Highlights cells without formula errors.

NotContainsText = 37

Highlights cells that do not contain the given text.

NotEqual = 38

.

ThisMonth = 15

Highlights cells containing dates in this month.

ThisWeek = 16

Highlights cells containing dates in this week.

ThreeColorScale = 40

Three Color Scale (Low, Middle and High Color Scale)

ThreeIconSet = 42

This conditional formatting rule applies a 3 set icons to cells according to their values.

Today = 17

Highlights cells containing todays date.

Tomorrow = 18

Highlights cells containing tomorrows date.

Top = 8

Highlights cells whose values fall in the top N bracket as specified.

TopPercent = 9

Highlights cells whose values fall in the top N percent as specified.

TwoColorScale = 41

Two Color Scale (Low and High Color Scale)

UniqueValues = 39

Highlights unique values in the range.

Yesterday = 19

Highlights cells containing yesterdays date.