This documentation is archived and is not being maintained.

XlFormatConditionOperator Enumeration 

Specifies the operator to use to compare a formula against the value in a cell or, for xlBetween and xlNotBetween, to compare two formulas.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

'Usage
Dim xlFormatConditionOperator1 As XlFormatConditionOperator = XlFormatConditionOperator.xlBetween

public enum XlFormatConditionOperator
public enum XlFormatConditionOperator
public enum XlFormatConditionOperator

Member nameDescription
xlBetweenBetween. Can only be used if two formulas are provided.
xlEqualEqual.
xlGreaterGreater than.
xlGreaterEqualGreater than or equal to.
xlLessLess than.
xlLessEqualLess than or equal to.
xlNotBetweenNot between. Can only be used if two formulas are provided.
xlNotEqualNot equal.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Show: