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.

​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.  Read More

​