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.Like so:Ingredient | Stock | Crab Cakes===========|=======|============Crab       |  Yes  | 12 ozMayonnaise |  No   | 1/4 cupJalapenos  |  Yes  |Egg        |  Yes  | 1Water      |  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.
Conditional formatting of a row header based on the values in the column
google spreadsheets;conditional formatting