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