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

2

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.

enter image description here

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

4

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy