FormatConditionCollectionAdd Method
Adds a formatting condition and effected cell rang to the FormatConditions The FormatConditions can contain up to three conditional formats. References to the other sheets are not allowed in the formulas of conditional formattin

Namespace: Aspose.Cells
Assembly: Aspose.Cells (in Aspose.Cells.dll) Version: 19.11.0.0 (19.11)
Syntax
public int[] Add(
	CellArea cellArea,
	FormatConditionType type,
	OperatorType operatorType,
	string formula1,
	string formula2
)

Parameters

cellArea
Type: Aspose.CellsCellArea
Conditional formatted cell range.
type
Type: Aspose.CellsFormatConditionType
Type of conditional formatting.It could be one of the members of FormatConditionType.
operatorType
Type: Aspose.CellsOperatorType
Comparison operator.It could be one of the members of OperatorType.
formula1
Type: SystemString
The value or expression associated with conditional formatting.
formula2
Type: SystemString
The value or expression associated with conditional formatting

Return Value

Type: Int32
[0]:Formatting condition object index;[1] Effected cell rang index.
See Also