Conditional Formatting not highlighting selected cells when keyword is typed into a cell range unless it’s the first cell of the range

Hello everyone!

I’m working on a project for work and I’m running into an issue that I can’t solve.

I work for housekeeping at a large property and we will, from time to time, shuffle around housekeepers and move their areas. I’m trying to use conditional formatting to highlight cells that resemble the different areas the housekeepers can be assigned as green once someone assigns that section to a housekeeper so they know the area is covered.

So far, I’ve tried using =[Range of Cells that has a Data Validation drop list of different sections]={Name of Section from Data Validation Table} with the “Apply To” range being 4 cells several columns over from the Section Selection range.

The group of cells will only highlight when the Section name is in the first cell of the range but no others.

Any help would be greatly appreciated!