Conditional Formatting - Highlight data based on a cell input value

Hi,

I'm trying to make a sheet more user friendly. I can't seem to find any existing threads on the topic, so I might be using the wrong keywords to search. Basically, I have a list of individuals. To make it more user friendly, I have an input cell (G1). If I type Bob into G1 I'd like Bob to be highlighted in cells B2:D6.

Can anyone please provide some guidance on how to write the Conditional Formatting formula?

Out of curiosity, how would the formula differ if I wanted to highlight the row that Bob shows up in?

Thanks in advance.