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