TConditionalFormatKind Enumeration
Defines which kind of conditional formatting the rule contains.
Syntax
Unit: 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. |