add method

add(self, cell_area, type, operator_type, formula1, formula2)

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 formatting.

Returns

[0]:Formatting condition object index;[1] Effected cell rang index.


def add(self, cell_area, type, operator_type, formula1, formula2):
    ...
ParameterTypeDescription
cell_areaaspose.cells.CellAreaConditional formatted cell range.
typeaspose.cells.FormatConditionTypeType of conditional formatting.It could be one of the members of FormatConditionType.
operator_typeaspose.cells.OperatorTypeComparison operator.It could be one of the members of OperatorType.
formula1System.StringThe value or expression associated with conditional formatting.
formula2System.StringThe value or expression associated with conditional formatting

See Also

add_area method