I have the following data in Google Sheets:
A E my my dog great,foo is great paris,dog foo bar bar,car cat
I'm trying to do a format rule that highlights a cell, which
DOES NOT match any item from
A:A. But some values in
E:E Contain fields with values separated by commas.
I've seen an answer which highlights cells if they contain duplicates from the same column:
Essentially I would like to invert this formula, and allow to take multiple values from each cell.