Create a formulate that determines if the crew working meets the minimum manning requirements.?

I have 2 crews, each with 3 different specialties. Although we may operate with 5 people per crew, we need at least 3 people to fill each unique position. IE: Manager, Cook, Waiter are 3 unique positions. My calendar has a single column (Column A) with all the names listed, Column B their specialty, and Column C-Z days of the week. Above their names, reading across the days, I have the 3 minimum manning positions. I would like the corresponding cell above that day to change color to whether the crew that day meets all 3 specialties. What formula would I use in excel?