Spread Windows Forms 17
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / FormatConditionType Enumeration


In This Topic
    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
    MemberDescription
    AboveAverageConditionThis conditional formatting rule highlights cells that are above or below the average for all values in the range.
    BlanksConditionThis conditional formatting rule highlights cells that are completely blank.
    CellValueThis conditional formatting rule highlights cells base on cell value.
    ColorScaleThis conditional formatting rule creates a gradated color scale on the cells.
    CustomThis is a customized conditional formatting rule.
    DatabarThis conditional formatting rule displays a gradated data bar in the range of cells.
    ErrorsConditionThis conditional formatting rule highlights cells with formula errors.
    ExpressionThis conditional formatting rule contains a formula to evaluate.
    IconSetThis conditional formatting rule applies icons to cells according to their values.
    NoBlanksConditionThis conditional formatting rule highlights cells that are not blank.
    NoErrorsConditionThis conditional formatting rule highlights cells without formula errors.
    TextStringThis conditional formatting rule highlights cells base on cell text.
    TimePeriodThis conditional formatting rule highlights cells containing dates in the specified time period.
    Top10This conditional formatting rule highlights cells whose values fall in the top N or bottom N bracket, as specified.
    UniqueValuesThis 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

    See Also