SpreadsheetGear 2023
FormatConditionType Enumeration


SpreadsheetGear Namespace : FormatConditionType Enumeration
Specifies the type of conditional format.
Syntax
'Declaration
 
Public Enum FormatConditionType 
   Inherits System.Enum
'Usage
 
Dim instance As FormatConditionType
public enum FormatConditionType : System.Enum 
Members
MemberDescription
AboveAverageConditionSpecifies that the conditional format applies to cells which are above or below average values.
BlanksConditionSpecifies that the conditional format applies to blank cells.
CellValueSpecifies that the conditional format compares the value of the cell.
ColorScaleSpecifies that the conditional format is applied using color scales.
DatabarSpecifies that the conditional format is applied using data bars.
ErrorsConditionSpecifies that the conditional format applies to cells with an error.
ExpressionSpecifies that the conditional format contains a formula.
IconSetsSpecifies that the conditional format is applied using a set of icons.
NoBlanksConditionSpecifies that the conditional format applies to cells which are not blank.
NoErrorsConditionSpecifies that the conditional format applies to cells which do not have an error.
NoneSpecifies no format condition type
TextStringSpecifies that the conditional format searches for the presence or absence of a specified string.
TimePeriodSpecifies that the conditional format applies to cells within a specified time period.
Top10Specifies that the conditional format applies to cells which rank in the top or bottom of values.
UniqueValuesSpecifies that the conditional format applies to cells which have duplicate or unique values.
Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         SpreadsheetGear.FormatConditionType

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

SpreadsheetGear Namespace