Conditional Formatting - Highlight data based on a cell input value

[RecycleBin_Rob]

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.

[#2 · Accepted solution]

@RecycleBin_Rob 

In the attached file i've entered rules for conditional formatting of only the matching cell and the whole row (from column B to column D).

[#3]

You've come to my aid again. Thanks so much!