Excel conditional formatting formula to highlight row if a cell contains a text

I'm trying to highlight rows when a cell value contains a text I specify.

This is what I have so far:

=ISNUMBER(SEARCH("yes",B:B))

and this is the sheet

a yes 43
b no 2
c maybe 43
d ok 7897
e yea 21
f hmm 6
g oo 1
h noo 6
i yaa 1
j yea 85
k hmm 8
l yes 8

The result I want is the first and last row to be highlighted since they both contain the word "yes" at the second column.

Thanks

1 Answer

To highlight entire Row in your case, you need to select both Columns, and assign this formula =$B2 = "yes", instead of the Formula you have applied earlier.

Just check the Screen Shot, it's highlighted Rows.

I do believe this Solution work for you, in case it differs just make a comment I'll alter the Solution.