Table of Contents

TConditionalFormatKind Enumeration

Defines which kind of conditional formatting the rule contains.

Syntax

Namespace: FlexCel.Core

Members

Name Value Description
Expression 0 When the formula is true, then the conditional format is applied.
CellIs 1 Compares the cell with another cell.
ColorScale 2 The rule is a color scale.
DataBar 3 The rule is data bars.
IconSet 4 The rule uses an icon set.
TopN 5 The rule is a top N.
UniqueValues 6 The rule highlights unique values.
DuplicateValues 7 The rule highlights duplicated values.
ContainsText 8 The rule highlights cells that contain some text.
NotContainsText 9 The rule highlights cells that doesn't contain some text.
BeginsWith 10 The rule highlights cells that beign with some text.
EndsWith 11 The rule highlights cells that end with some text.
ContainsBlanks 12 The rule highlights empty cells.
NotContainsBlanks 13 The rule highlights non empty cells.
ContainsErrors 14 The rule highlights cells that contain errors.
NotContainsErrors 15 The rule highlights cells that don't contain errors.
TimePeriod 16 The rule highlights dates inside a range.
AboveAverage 17 This rule highlights cells which are above or below average.