Click or drag to resize

XlsConditionalFormats AddCellValueCondition Method (ComparisonOperatorType, String, String)

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,
	string value1,
	string value2
)

Parameters

operatorType
Type: Spire.Xls ComparisonOperatorType
The Comparison operator for conditional formatting in Excel.
value1
Type: System String
The first value
value2
Type: System String
The second value .If the operatorTypy is Equal or NotEqual or Greater or Less or GreaterOrEqual or LessOrEqual, then this parameter must use string.Empty or null

Return Value

Type: IConditionalFormat
See Also