0

I have a Google Sheet set up with place names in column B as below.

enter image description here

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.

enter image description here

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.

enter image description here

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.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.