I have the following data in Google Sheets:

A       E
my      my
dog     great,foo
great   paris,dog
bar     bar,car

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.

Many Thanks

migrated from superuser.com May 23 at 4:06

This question came from our site for computer enthusiasts and power users.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.