I have a Google sheet which has a column for business name (A) and a column for city (B). I would like to set conditional formatting such that if the city name is contained within the business name on the same row, the business name will be highlighted.

CodePudding user response：

=REGEXMATCH ($A2,$B2) would do the work too!