Spread WPF 17
GrapeCity.Excel Namespace / ExcelConditionalFormatType Enumeration


In This Topic
    ExcelConditionalFormatType Enumeration
    In This Topic
    Represent conditional formatting type.
    Syntax
    'Declaration
 
Public Enum ExcelConditionalFormatType 
   Inherits System.Enum
    'Usage
 
Dim instance As ExcelConditionalFormatType
    public enum ExcelConditionalFormatType : System.Enum
    Members
    MemberDescription
    AboveAverageThis conditional formatting rule highlights cells that are above the average for all values in the range.
    AboveOrEqualToAverageThis conditional formatting rule highlights cells that are above or equals to the average for all values in the range.
    BeginsWithThis conditional formatting rule highlights cells in the range that begin with the given text. Equivalent to using the LEFT() sheet function and comparing values
    BelowAverageThis conditional formatting rule highlights cells that are below the average for all values in the range.
    BelowOrEqualToAverageThis conditional formatting rule highlights cells that are below or equals the average for all values in the range.
    CellIsThis conditional formatting rule compares a cell value to a formula calculated result, using an operator.
    ColorScaleThis conditional formatting rule creates a gradated color scale on the cells.
    ContainsBlanksThis conditional formatting rule highlights cells that are completely blank. Equivalent of using LEN(TRIM()). This means that if the cell contains only characters that TRIM() would remove, then it is considered blank.
    ContainsErrorsThis conditional formatting rule highlights cells with formula errors. Equivalent to using ISERROR() sheet function to determine if there is a formula error.
    ContainsTextThis conditional formatting rule highlights cells containing given text. Equivalent to using the SEARCH() sheet function to determine whether the cell contains the text.
    DataBarThis conditional formatting rule displays a gradated data bar in the range of cells.
    DuplicateValuesThis conditional formatting rule highlights duplicated values.
    EndsWithThis conditional formatting rule highlights cells ending with given text. Equivalent to using the RIGHT() sheet function and comparing values.
    ExpressionThis conditional formatting rule contains a formula to evaluate. When the formula result is true, the cell is highlighted.
    IconSetThis conditional formatting rule applies icons to cells according to their values.
    Last7DaysA date in the last seven days.
    LastMonthA date occurring in the last calendar month.
    LastWeekA date occurring last week.
    NextMonthA date occurring in the next calendar month.
    NextWeekA date occurring next week.
    NotContainsBlanksThis conditional formatting rule highlights cells that are not blank. Equivalent of using LEN(TRIM()). This means that if the cell contains only characters that TRIM() would remove, then it is considered blank
    NotContainsErrorsThis conditional formatting rule highlights cells without formula errors. Equivalent to using ISERROR() sheet function to determine if there is a formula error.
    NotContainsTextThis conditional formatting rule highlights cells that do not contain given text. Equivalent to using the SEARCH() sheet function.
    ThisMonthA date occurring in this calendar month.
    ThisWeekA date occurring this week.
    TimePeriodThis conditional formatting rule highlights cells containing dates in the specified time period. The underlying value of the cell is evaluated, therefore the cell does not need to be formatted as a date to be evaluated.
    TodayToday's date.
    TomorrowTomorrow's date.
    Top10This conditional formatting rule highlights cells whose values fall in the top N or bottom N bracket, as specified.
    UniqueValuesThis conditional formatting rule highlights unique values in the range.
    YesterdayYesterday's date.
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             GrapeCity.Excel.ExcelConditionalFormatType

    See Also

    Reference

    GrapeCity.Excel Namespace