'Declaration
 
Overloads Function Add( _
   ByVal type As FormatConditionType, _
   Optional ByVal operator As FormatConditionOperator, _
   Optional ByVal formula1 As String, _
   Optional ByVal formula2 As String, _
   Optional ByVal textOperator As ContainsOperator, _
   Optional ByVal dateOperator As TimePeriods _
) As IFormatCondition

'Usage
 
Dim instance As IFormatConditions
Dim type As FormatConditionType
Dim operator As FormatConditionOperator
Dim formula1 As String
Dim formula2 As String
Dim textOperator As ContainsOperator
Dim dateOperator As TimePeriods
Dim value As IFormatCondition
 
value = instance.Add(type, operator, formula1, formula2, textOperator, dateOperator)

IFormatCondition Add( 
   FormatConditionType type,
   FormatConditionOperator operator,
   string formula1,
   string formula2,
   ContainsOperator textOperator,
   TimePeriods dateOperator
)

Parameters

type

Specifies whether the conditional format is based on a cell value or an expression.

operator

The conditional format operator. If type is FormatConditionType.TextString or FormatConditionType.Expression, it'll be ignored.

formula1

The value or expression associated with the conditional format. Can be a constant value, a string value, a cell reference, or a formula.

formula2

The value or expression associated with the second part of the conditional format when Operator is xlBetween or xlNotBetween (otherwise, this argument is ignored). Can be a constant value, a string value, a cell reference, or a formula.

textOperator

The conditional format text operator. If type isn't FormatConditionType.TextString, it'll be ignored.

dateOperator

The date operator used in the format condition.

Return Value

Reference

IFormatConditions Interface
IFormatConditions Members
Overload List