ExcelConditionalFormatType Enumeration |
The type of a conditional format rule.
Namespace: ExpertXls.ExcelLibAssembly: expertxls (in expertxls.dll) Version: 10.0.0
Syntaxpublic enum ExcelConditionalFormatType
Public Enumeration ExcelConditionalFormatType
Members| Member name | Value | Description |
|---|
| CellValue | 0 |
Formats the cells whose value meets a comparison with one or two values, for example greater than 100.
|
| Formula | 1 |
Formats the cells for which a formula evaluates to TRUE.
|
| ColorScale | 2 |
Fills the cells with a two or three color gradient based on their values.
|
| DataBar | 3 |
Draws a bar in each cell, with a length proportional to the cell value.
|
| IconSet | 4 |
Displays an icon in each cell, chosen by the cell value.
|
| Other | 5 |
Another type of rule, for example a rule loaded from an existing workbook (top 10, above average, duplicate values).
|
See Also