Database filtering help

****Please note: If you apply, please send back your idea of your approach to this project. If you don't send over your approach, I will not review your application.****

We have a spreadsheet of around 4,000 dog & cat food products. Each product has an ingredient list of what is in that specific food. We need a way to filter the ingredients to show foods that have certain ingredients.

i.e. All of the foods on this website, along with the ingredients, are in a spreadsheet format: ----------

I need to see the foods that have none of the following ingredients in them: Chicken, Rice, Flaxseed, and Peas

If a food has Chicken &/or Flaxseed in it, I need to see those specific ingredients (not the entire food or all of the ingredient names) highlighted in red.

If a food has Rice &/or Peas in it, I need to see those specific ingredients (not the entire food or all of the ingredient names) highlighted in yellow.

I don't know the best way to do this. We tried filtering in excel but it highlights the entire cell - not the specific ingredient item.

I need ideas! And I need inexpensive and fast ideas.