One way:

Select A5. Choose Format/Conditional Formatting...

CF1: Formula is =COUNTIF(A5,"*needs training*")
Format1: <your format here

In article ,
George Lynch wrote:

I need to create a conditional format based on a text string that will be
contained in a larger text string within the active cell. I know I can use
either the SEARCH or FIND function to determine if a text string is contained
within a larger string, but those functions require a cell address and I
don't know how to apply them to the current cell address, whatever it might
be.

So, for example, if the text string is "needs training", and the text in
cell A5 is "George has had some exposure to the app, but he needs training",
then I would want that cell to apply a conditional format because the phrase
"needs training" is contained in the cell.

Thanks in advance for any advice on this...