Hey,
Ok So in the TAB "Base-Meal Layout), I need to have cells (K1:K9), (K19:K21), (K31:K33), (K43:K45), (K55:K57), (K67:K69), and (K79:K81) to either turn BLACK or RED based off of J3 and L3 which will correspond to tables set up in the TAB "Choice Food Calculations" from cells F43 : AA59. I think vlook up will work, so for example cell K7 will turn RED Because Type I with 7 Meals has an "X" in the protein portion in Meal 1 as seen in the TAB "Choice Food Calculations" from cells F43 : AA59
Solved by Z. D. in 11 mins