I have a spreadsheet which contains a list of people (A new row for each person. Information on home country, organisation, contact number etc.. are in columns A-Z).
I want to highlight any cell in columns I, J and K which contain specific 'key words'. The column of key words is located on the same workbook but a different sheet called "Custom search" (cells B2-B62).
I need it to highlight any cell which contains one of the key words even if there is other text in the cell.
Solved by B. Y. in 12 mins