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