FormatConditionType Enum

Namespace:
GemBox.Spreadsheet.ConditionalFormatting
Assembly:
GemBox.Spreadsheet.dll

Represents a FormatCondition type.

public enum FormatConditionType
Public Enum FormatConditionType

Fields

AboveOrBelowAverage

Formats only cells with values that are above or below average.

ColorScale

Formats fill of all cells based on their values using a specified 2-point or 3-point color scale.

Contain

Formats only cells that contain value which satisfies the specified criteria.

DataBar

Formats all cells based on their values by displaying a data bar whose length is proportional to cell's value.

Formula

Formats only cells for which the specified formula result evaluates to true.

IconSet

Formats all cells based on their values by displaying an icon from the specified icon set according to cell's value.

TopOrBottomRanked

Formats only cells with top or bottom ranked values.

UniqueOrDuplicate

Formats only cells with unique or duplicate values.