In Google Sheets I have two columns, A and B, and want to know when a cell in column A contains a word that is not in column B.
Column A contains cells with multiple words per cell, comma separated:
sarah, john, esther
Column B contains one word per cell like:
I want to know when a word in the first column is not in the second column. In our example, that would be
Ideally that cell would go red, or another cell in the same row would show a warning.