use conditional formatting – test that contains – then highlight all criteria with red fill.

Then filter by colour.

 

boom

 

Conditional Formatting – Highlight Cell Rules – Text that contains

Highlight all the values you want to find