Modifies an existing conditional format.
Syntax
'Declaration
Overloads Function Modify( _
ByVal As FormatConditionType, _
Optional ByVal As FormatConditionOperator, _
Optional ByVal As String, _
Optional ByVal As String, _
Optional ByVal As ContainsOperator, _
Optional ByVal As TimePeriods _
) As Boolean
'Usage
Dim instance As IFormatCondition
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 Boolean
value = instance.Modify(type, operator, formula1, formula2, textOperator, dateOperator)
Parameters
- type
- Specifies whether the conditional format is based on a cell value or an expression.
- operator
- The conditional format operator. If 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 isn't FormatConditionType.TextString, it'll be ignored.
- dateOperator
- The date operator used in the format condition.
Return Value
true
if the conditional format is modified, false
otherwise.
See Also