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. |