'DeclarationPublic Enum FormatConditionType Inherits System.Enum
'UsageDim instance As FormatConditionType
public enum FormatConditionType : System.Enum
public enum FormatConditionType = class(System.Enum)
public enum FormatConditionType extends System.Enum
__value public enum FormatConditionType : public System.Enum
public enum class FormatConditionType : public System.Enum
| Member | Description |
|---|---|
| AboveAverageCondition | Specifies that the conditional format applies to cells which are above or below average values. |
| BlanksCondition | Specifies that the conditional format applies to blank cells. |
| CellValue | Specifies that the conditional format compares the value of the cell. |
| ColorScale | Specifies that the conditional format is applied using color scales. |
| Databar | Specifies that the conditional format is applied using data bars. |
| ErrorsCondition | Specifies that the conditional format applies to cells with an error. |
| Expression | Specifies that the conditional format contains a formula. |
| IconSets | Specifies that the conditional format is applied using a set of icons. |
| NoBlanksCondition | Specifies that the conditional format applies to cells which are not blank. |
| NoErrorsCondition | Specifies that the conditional format applies to cells which do not have an error. |
| None | Specifies no format condition type |
| TextString | Specifies that the conditional format searches for the presence or absence of a specified string. |
| TimePeriod | Specifies that the conditional format applies to cells within a specified time period. |
| Top10 | Specifies that the conditional format applies to cells which rank in the top or bottom of values. |
| UniqueValues | Specifies that the conditional format applies to cells which have duplicate or unique values. |
System.Object
System.ValueType
System.Enum
SpreadsheetGear.FormatConditionType
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