Function to find "Invalid" in a string

[JMay]

Is there a function to find a test string within another test string?
I need to find the cells within the Range a1:a2000 which include the
text "Invalid" anywhere within the Cells A1:A2000.
But How?
Not Find() or Search(), but What?

 

[Vasant Nanavati]

Hi:

For a non-programming solution, why not use conditional formatting? Select
the range with A1 active, then from the menu, do Format | Conditional
Formatting | Formula Is | =SEARCH("invalid",A1)>0 | Color red.

Regards,

Vasant.