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!
' add conditional formatting for $100K threshold
Range("I3").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=AND(ISERROR(SEARCH(""Total"",C3)),OR(I3<=-0.1,I3>=0.1))"
Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
With Selection.FormatConditions(1).Interior
.PatternColorIndex = xlAutomatic
.Color = 65535
.TintAndShade = 0
End With
Selection.FormatConditions(1).StopIfTrue = False
Bookmarks