Highlighting compounds of other words in a list

[Dandy]

Hi,

I'm trying to find a solution to a variant of the "duplicate" problem. In particular, I need to find out if a mixed list containing compound nouns also contains their parts, and if this is the case, I want both words to be highlighted via conditional formatting. Example: If the list contains "rainbow" and "rain", I want both highlighted. I already know how to highlight "rain" given "rainbow", but now I need the opposite, too.

I'd be very grateful for help (note: I'm on a Mac, so I can't use VBA, otherwise I would have tried that approach, too).