Enum eExcelConditionalFormattingRuleType

Namespace

OfficeOpenXml.ConditionalFormatting

Assembly

Magicodes.EPPlus.dll

public enum eExcelConditionalFormattingRuleType

Extension Methods

ExtensionMethods.IsNumeric(object)

Fields

AboveAverage = 0

AboveOrEqualAverage = 1

AboveStdDev = 4

BeginsWith = 20

BelowAverage = 2

BelowOrEqualAverage = 3

BelowStdDev = 5

Between = 21

Bottom = 6

BottomPercent = 7

ContainsBlanks = 22

ContainsErrors = 23

ContainsText = 24

DataBar = 45

DuplicateValues = 25

EndsWith = 26

Equal = 27

Expression = 28

FiveIconSet = 44

FourIconSet = 43

GreaterThan = 29

GreaterThanOrEqual = 30

Last7Days = 10

LastMonth = 11

LastWeek = 12

LessThan = 31

LessThanOrEqual = 32

NextMonth = 13

NextWeek = 14

NotBetween = 33

NotContains = 34

NotContainsBlanks = 35

NotContainsErrors = 36

NotContainsText = 37

NotEqual = 38

ThisMonth = 15

ThisWeek = 16

ThreeColorScale = 40

ThreeIconSet = 42

Today = 17

Tomorrow = 18

Top = 8

TopPercent = 9

TwoColorScale = 41

UniqueValues = 39

Yesterday = 19