I see several similar questions on the forum but not quite the same and the answers don't seem to extend to my situation.
I have an Excel sheet that schedules people for weekend support. I am also using a data validation cell/menu where I can select the engineer from the drop down menu. What I want is when I select that name from the validation cell, I want any of the cells in the column to highlight if that person is in that list.
So - I have Column B with a list of names that may look like this:
In Cell C3 I have the data validation menu with the selections of: Fred; George; Harry; Remus; Ron
When I select George from the menu I want the cells in B to highlight if they have George in them.
I tried the following example I have seen in multiple places:
I tried that in a cell formula and I also tried setting it up in Conditional Formatting. I'm just not getting the flow right. I've tried adjusting values around but the best I came up with was cell C3 highlighting.
I don't want to hard code "George" into the formula because that name will change. In reality the list is longer, and this sheet is intended for all the team so they can find their name in the schedule quickly.
I hope I've explained myself well enough. If not, please let me know.