FormatConditionType Enumeration

In This Topic

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

Syntax

'Declaration
 
Public Enum FormatConditionType 
   Inherits System.Enum

'Usage
 
Dim instance As FormatConditionType

public enum FormatConditionType : System.Enum

Members

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

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         GrapeCity.Spreadsheet.FormatConditionType