Quote Originally Posted by Bob Umlas
You can define a function to return true if it contains one of those
characters, then use conditional formatting in that range to turn cells red
and reference the function, like
=SpecChar(A1) where A1 is the active cell when you use the conditional
formatting, and SpecChar is defined as:
Public Function SpecChar(rg) As Boolean
For Each thing In rg
If InStr(thing.Formula, "+") > 0 Or _
InStr(thing.Formula, "-") > 0 Or _
InStr(thing.Formula, "/") > 0 Or _
InStr(thing.Formula, "*") > 0 Then
SpecChar = True
Exit Function
End If
Next
End Function
Bob,

thanks, but how do I define a function?

KR