Multiple Criteria Filtering

 

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

Then filter by colour.

 

boom

 

Advertisements