Class ComparisonOperator

The conditional format operators used for "Highlight Cells That Contain..." rules.

Inheritance

System.Object

ComparisonOperator

Namespace: IronXL.Formatting.Enums

Assembly: IronXL.dll

Syntax

public sealed class ComparisonOperator : Enum

ComparisonOperator chooses the test a conditional formatting rule applies to a cell, passed to CreateConditionalFormattingRule and read from ConditionalFormattingRule.ComparisonOperation. LessThan, GreaterThan, Equal, NotEqual, and the OrEqual variants test a single value, while Between and NotBetween check a low and high bound. NoComparison marks a category rule such as a color scale. This is the conditional formatting operator in IronXL.Formatting.Enums, separate from the same-named type in IronXL.DataValidations, which has no NoComparison value. The conditional formatting how-to shows operator-driven rules.

var rule = sheet.ConditionalFormatting.CreateConditionalFormattingRule(ComparisonOperator.LessThan, "8");

Fields

Between

'Between' operator

Declaration

public const ComparisonOperator Between

Field Value

Type	Description
ComparisonOperator

Equal

'Equal to' operator

Declaration

public const ComparisonOperator Equal

Field Value

Type	Description
ComparisonOperator

GreaterThan

'Greater than' operator

Declaration

public const ComparisonOperator GreaterThan

Field Value

Type	Description
ComparisonOperator

GreaterThanOrEqual

'Greater than or equal to' operator

Declaration

public const ComparisonOperator GreaterThanOrEqual

Field Value

Type	Description
ComparisonOperator

LessThan

'Less than' operator

Declaration

public const ComparisonOperator LessThan

Field Value

Type	Description
ComparisonOperator

LessThanOrEqual

'Less than or equal to' operator

Declaration

public const ComparisonOperator LessThanOrEqual

Field Value

Type	Description
ComparisonOperator

NoComparison

The default value.

Declaration

public const ComparisonOperator NoComparison

Field Value

Type	Description
ComparisonOperator

NotBetween

'Not between' operator

Declaration

public const ComparisonOperator NotBetween

Field Value

Type	Description
ComparisonOperator

NotEqual

'Not equal to' operator

Declaration

public const ComparisonOperator NotEqual

Field Value

Type	Description
ComparisonOperator

value__

Declaration

public byte value__

Field Value

Type	Description
System.Byte