Class
BetweenRule

Conditional formatting rule that applies formatting when a cell value falls between two specified bounds, inclusive.

Definition

Constructors

BetweenRule(string, string)

Initializes a new BetweenRule with two boundary arguments.

Declaration

cs-api-definition
[Obsolete("This constructor is obsoleted, please use the one with 3 parameters instead.")]
public BetweenRule(string argument1, string argument2)

Parameters

argument1

string

argument2

string

BetweenRule(string, string, DifferentialFormatting)

Initializes a new instance of the BetweenRule class.

Declaration

cs-api-definition
public BetweenRule(string argument1, string argument2, DifferentialFormatting formatting)

Parameters

argument1

string

argument2

string

formatting

DifferentialFormatting

Methods

Resolve(ICellValue)

Evaluates whether the cell value falls between 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)