Here's my example data set:
The conditional formatting window looks like this:
The rule applies to =$A$2:$D$13 (entire data table except for the header row)
The base formula used is =ISNUMBER(SEARCH(substring,text))
Don't forget to make an absolute reference to the cell containing the search word (substring). For the text, make sure the column has an absolute reference starting in the top-left corner of first data entry, and rows have a relative reference (this is already done in the formula shown above, but I'm just elaborating on it here in general in case you do something similar in the future)
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…