View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
geebee geebee is offline
external usenet poster
 
Posts: 190
Default 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