I have a table I'm using to list recipes and their ingredients. Ingredients are rows, recipes are columns, with a column next to the ingredients denoting if that ingredient is in stock.
Ingredient | Stock | Crab Cakes ===========|=======|============ Crab | Yes | 12 oz Mayonnaise | No | 1/4 cup Jalapenos | Yes | Egg | Yes | 1 Water | Yes |
What I would like to do is create a conditional format that checks if an all ingredients listed in a row are in stock, and if so, changes the color of the row header.
It feel like it should be fairly simple, but I am at a loss.