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