Hello,
I am creating format conditions. Then I am trying to updating them. But am
getting an error.

So for example I have this:

Dim x As Excel.FormatConditions
Dim y As Excel.FormatCondition

Set x = Excel.Range("D3").FormatConditions
x.Add Type:=xlExpression, Formula1:="=A1"
Set y = x(1)

'this is causing an error
y.Formula1 "=B2"

is there a way to update the formula? Without deleting and re-adding the
format?

thanks

Greg,

I think the method to use to update a format condition is MODIFY as
in

Worksheets(1).Range("d3").FormatConditions(1) _
.Modify Type:=xlExpression, Formula1:="=A1"

Catherine