Multiple keyword in a single cell. Possible to filter words separately in dropdown menu?

Hi!

E.g.
• Cell in row 1 has "red, blue, yellow"
• Cell in row 2 has "red, green, purple"
• Cell in row 3 has "orange, purple"

Is it possible to filter these separately in the drop-down menu? For example, if I pulled down the drop-down menu, I'd see separate checkboxes for "red", "blue", "yellow", "green", "purple", and "orange". And if I checked "red"...only rows 1 and 2 would show up. If I checked "purple"...only rows 2 and 3 show up. Etc.

I am aware of the custom text filter option to filter what contains a specific text. But as other users should use the file, a dropdown menu where you can see all keywords is required.

Can anyone edit my attached example file to show me how it works? That would be very kind, thanks!