I have a Google Sheet set up with place names in column B as below.
I have another tab on the same spreadsheet with a list that can change from time to time depending on which stores needs items fixing as below.
I need a way of highlighting the cells in column A when the text in column B is listed in in the other tab, as below.
I have typed "AMENDS" into A11 as an example of how I would like it to look/work.
Any help on this would be much appreciated.