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).
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).