Click or drag to resize

XlsConditionalFormats AddCellValueCondition Method (ComparisonOperatorType, Double, Double)

Add new cell value condition to the collection.

Namespace: Spire.Xls.Core.Spreadsheet.Collections
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
public IConditionalFormat AddCellValueCondition(
	ComparisonOperatorType operatorType,
	double value1,
	double value2
)

Parameters

operatorType
Type: Spire.Xls ComparisonOperatorType
The Comparison operator for conditional formatting in Excel.
value1
Type: System Double
The first value
value2
Type: System Double
The second value.If the operatorTypy is Equal or NotEqual or Greater or Less or GreaterOrEqual or LessOrEqual, then this parameter must use ***double.NaN***.Don't use null

Return Value

Type: IConditionalFormat
See Also