SharpCell

ConditionalOperator

public enum ConditionalOperator

Namespace SharpCell · package SharpCell

How a ConditionalFormatType.CellValue rule compares the cell's value with its formulas.

Values

Name Value Description
Between 0 From the first formula to the second, both included.
NotBetween 1 Less than the first formula or greater than the second.
Equal 2 Equal to the first formula; text ignoring case.
NotEqual 3 Not equal to the first formula.
GreaterThan 4 Greater than the first formula.
LessThan 5 Less than the first formula.
GreaterThanOrEqual 6 Greater than or equal to the first formula.
LessThanOrEqual 7 Less than or equal to the first formula.