Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formatting
Is that a space after the "D"?
-- Jim "geebee" (noSPAMs) wrote in message ... | 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 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |