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