VBA conditional formatting variables

Hi.... this is my first post, ever, but thanks in advance to all.... great forum, with lots of really sharp people!

the below rutine works fine, but I'd like to request the user to supply the threshold value (and, i would validate their input)

Can anyone show me how to pass the value from inputbox so i can replace the hardcoded 0.1 below. I've tried:

"=AND(ISERROR(SEARCH(""Total"",C3)),OR("I3<=-" & MyValue,"I3>=" & MyValue))" but without success THANKS!

Please Login or Register  to view this content.