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
)
 
Public Function AddCellValueCondition ( 
	operatorType As ComparisonOperatorType,
	value1 As Double,
	value2 As Double
) As IConditionalFormat
 
public:
IConditionalFormat^ AddCellValueCondition(
	ComparisonOperatorType operatorType, 
	double value1, 
	double value2
)
 
member AddCellValueCondition : 
operatorType : ComparisonOperatorType * 
value1 : float * 
value2 : float -> IConditionalFormat 
 
 
 
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