conditional formatting
hi,
i have the following:
dim z as integer
for z = 8 to 100
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=ROUND(D " & z & ",3)=$B$5"
next z
for some reason i am getting a runtime error 5 error message: invalid
procedure call or argument. im not sure why.
thanks in advance,
geebee
|