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