FormatConditionOperator Enumeration

Constants which specify the manner in which a cell value is compared against one or more operands.

Syntax

Visual Basic

'Declaration
 
Public Enum FormatConditionOperator 
   Inherits System.Enum

C#

public enum FormatConditionOperator : System.Enum 

Members

Member	Description
Between	The condition evaluates to true if the cell value is between the values of the two operands.
Equal	The condition evaluates to true if the cell value is equal to the value of the operand.
Greater	The condition evaluates to true if the cell value is greater than the value of the operand.
GreaterEqual	The condition evaluates to true if the cell value is greater than or equal to the value of the operand.
Less	The condition evaluates to true if the cell value is less than the value of the operand.
LessEqual	The condition evaluates to true if the cell value is less than or equal to the value of the operand.
NotBetween	The condition evaluates to true if the cell value is not between the values of the two operands.
NotEqual	The condition evaluates to true if the cell value is not equal to the value of the operand.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, 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