Search GSheets for Criteria, Highlight Them Red

[meowmeow22]

Hi excelhelpforum team,
Thanks for your help in the past, I have posted a lot.

We are in Google Sheets (attached), and want to search Job Title column for any of 60 terms. Once the term is found, we want to highlight the entire row red.

Let's say the "no list" is Associate Investment Director and Managing Director for column B.

Thanks again,
AS

[Flyboy65]

Here's a solution for highlighting a single row based on a single title selection. Someone else with more knowledge may be able to help you for highlighting multiple rows.

https://docs.google.com/spreadsheets...it?usp=sharing

[meowmeow22]

Thanks, Flyboy. Let me give it a shot. Yes, still looking for a multi-highlighter.

[meowmeow22]

Just requested Edit access

[janmorris]

@meowmeow22...

just click File > Make a copy, then you will have your own copy to test.