ExcelConditionalFormatType Enumeration

Represent conditional formatting type.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum ExcelConditionalFormatType 
   Inherits System.Enum

'Usage
 
Dim instance As ExcelConditionalFormatType

public enum ExcelConditionalFormatType : System.Enum

Members

Member	Description
AboveAverage	This conditional formatting rule highlights cells that are above the average for all values in the range.
AboveOrEqualToAverage	This conditional formatting rule highlights cells that are above or equals to the average for all values in the range.
BeginsWith	This conditional formatting rule highlights cells in the range that begin with the given text. Equivalent to using the LEFT() sheet function and comparing values
BelowAverage	This conditional formatting rule highlights cells that are below the average for all values in the range.
BelowOrEqualToAverage	This conditional formatting rule highlights cells that are below or equals the average for all values in the range.
CellIs	This conditional formatting rule compares a cell value to a formula calculated result, using an operator.
ColorScale	This conditional formatting rule creates a gradated color scale on the cells.
ContainsBlanks	This 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.
ContainsErrors	This conditional formatting rule highlights cells with formula errors. Equivalent to using ISERROR() sheet function to determine if there is a formula error.
ContainsText	This conditional formatting rule highlights cells containing given text. Equivalent to using the SEARCH() sheet function to determine whether the cell contains the text.
DataBar	This conditional formatting rule displays a gradated data bar in the range of cells.
DuplicateValues	This conditional formatting rule highlights duplicated values.
EndsWith	This conditional formatting rule highlights cells ending with given text. Equivalent to using the RIGHT() sheet function and comparing values.
Expression	This conditional formatting rule contains a formula to evaluate. When the formula result is true, the cell is highlighted.
IconSet	This conditional formatting rule applies icons to cells according to their values.
Last7Days	A date in the last seven days.
LastMonth	A date occurring in the last calendar month.
LastWeek	A date occurring last week.
NextMonth	A date occurring in the next calendar month.
NextWeek	A date occurring next week.
NotContainsBlanks	This 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
NotContainsErrors	This conditional formatting rule highlights cells without formula errors. Equivalent to using ISERROR() sheet function to determine if there is a formula error.
NotContainsText	This conditional formatting rule highlights cells that do not contain given text. Equivalent to using the SEARCH() sheet function.
ThisMonth	A date occurring in this calendar month.
ThisWeek	A date occurring this week.
TimePeriod	This 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.
Today	Today's date.
Tomorrow	Tomorrow's date.
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 unique values in the range.
Yesterday	Yesterday's date.

Inheritance Hierarchy

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

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

GrapeCity.Excel Namespace