Is it possible to automatically highlight part of the text inside the cell if it matches a range of values?
e.g. the column A has these values:
The exclusion list in B has the Deputy Mayor and Member of the Board:
The expected result of conditional formatting:
1