GrapeCity.Spreadsheet.FormatConditionType

FormatConditionType Enum

Specifies whether the conditional format is based on a cell value or an expression.

public enum FormatConditionType

Public Enum FormatConditionType

Name	Description
AboveAverageCondition	This conditional formatting rule highlights cells that are above or below the average for all values in the range.
BlanksCondition	This conditional formatting rule highlights cells that are completely blank.
CellValue	This conditional formatting rule highlights cells base on cell value.
ColorScale	This conditional formatting rule creates a gradated color scale on the cells.
Custom	This is a customized conditional formatting rule.
Databar	This conditional formatting rule displays a gradated data bar in the range of cells.
ErrorsCondition	This conditional formatting rule highlights cells with formula errors.
Expression	This conditional formatting rule contains a formula to evaluate.
IconSet	This conditional formatting rule applies icons to cells according to their values.
NoBlanksCondition	This conditional formatting rule highlights cells that are not blank.
NoErrorsCondition	This conditional formatting rule highlights cells without formula errors.
TextString	This conditional formatting rule highlights cells base on cell text.
TimePeriod	This conditional formatting rule highlights cells containing dates in the specified time period.
Top10	This conditional formatting rule highlights cells whose values fall in the top N or bottom N bracket, as specified.
UniqueValues	This conditional formatting rule highlights cells that contain unique value or duplicated values in the range.