excel - Contains a string in a cell

Question

I'm trying to do conditional highlighting in Excel that would highlight the entire row of a cell if the cell contains a string.

Say I would like to determine if the cell contains the word "done". The cell can contain such text and would still be able highlight the cell:

1. done
2. It is done
3. abcdone

question from:https://stackoverflow.com/questions/65907051/contains-a-string-in-a-cell

Answer 1

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)