Class
NotBetweenRule

Conditional formatting rule that applies formatting when a cell value falls outside the range defined by two specified bounds.

Definition

Constructors

NotBetweenRule(string, string)

Initializes a new NotBetweenRule with two boundary arguments.

Declaration

cs-api-definition
[Obsolete("This constructor is obsoleted, please use the one with formatting parameter instead.")]
public NotBetweenRule(string first, string second)

Parameters

first

string

second

string

NotBetweenRule(string, string, DifferentialFormatting)

Initializes a new NotBetweenRule with two boundary arguments and formatting to apply when the condition is met.

Declaration

cs-api-definition
public NotBetweenRule(string first, string second, DifferentialFormatting formatting)

Parameters

first

string

second

string

formatting

DifferentialFormatting

Methods

Resolve(ICellValue)

Evaluates whether the cell value falls outside the range defined by the two boundary arguments and returns 1.0 if true, 0.0 otherwise.

Declaration

cs-api-definition
protected override double Resolve(ICellValue value)

Parameters

value

ICellValue

The cell value

Returns

double

Overrides ConditionalFormattingRule.Resolve(ICellValue)