Click or drag to resize

ExcelConditionalFormatType Enumeration

The type of a conditional format rule.

Namespace: ExpertXls.ExcelLib
Assembly: expertxls (in expertxls.dll) Version: 10.0.0
Syntax
public enum ExcelConditionalFormatType
Members
Member nameValueDescription
CellValue0 Formats the cells whose value meets a comparison with one or two values, for example greater than 100.
Formula1 Formats the cells for which a formula evaluates to TRUE.
ColorScale2 Fills the cells with a two or three color gradient based on their values.
DataBar3 Draws a bar in each cell, with a length proportional to the cell value.
IconSet4 Displays an icon in each cell, chosen by the cell value.
Other5 Another type of rule, for example a rule loaded from an existing workbook (top 10, above average, duplicate values).
See Also