Conditional format if value contains *Text* (with wildcards)


Conditional formatting With Formula Is,


=SEARCH("TEXT",A1)

Where A1 is the cell of interest. Make sure the A1 is not locked (like $A$1).