Compare and find missing data in 2 columns with multiple lines in single cell

[Chantilly]

Hello,

I'm looking to compare 2 columns on a single sheet that have multiple lines within a single cell (text values). I would like to highlight or pull the missing data of all text in Column A that does NOT show up in Column B (OR highlight/pull data of all the matching text), but since there are multiple values within a single cell, I'm struggling to figure out how to do this.

Example:

Column A	Column B
Henry Joan Alice	John
Peter
Mary	Alice
	Henry Peter
Fred	Joan Mary

*In this example, Henry, Joan and Alice are in a single cell in Column A, and show up in Column B (either singularly in a cell or multiple lines in a cell)...so they should match (be true, etc.)
But Fred would be the missing data - as Fred is listed in Column A but not in Column B. I would like to either highlight or pull the text data of "Fred" showing that there is no match in Column B. Or alternatively, highlight all the matching data between the 2 columns and not the missing data (ie. Henry, Joan, Alice, Peter, Mary).

I have tried conditional formatting and Vlookup, but again, the issue of the multiple lines in a single cell makes it not work the way I'm needing.

Is there any way to do this??

Please help!

Thank you!!!