Verifying Totals with Conditional Formatting

[LankyOgre]

I have created a chart that has a list of names that belong to numbered groups with favorite food. I want to have a chart display the breakdown of favorite food by group number, i.e. how many names in group 1 like apples. I have figured out how to do that with countifs. I then want an extra column to verify that all names have been used, so I want it to countif(names in group 1). If the number does not match the total of all group 1 favorite foods, I want it to turn red. Is there an easy way to do that with Conditional Formatting?

[JohnTopley]

It would help if you could post a small sample file illustrating what is required.

Click "Go Advanced" then "Paper Clip" icon to upload a file.

[LankyOgre]

So I have a list of favorite fruits. I'm counting how many of each fruit are liked by each group.
Is there a way to add in a cell where the x is a formula to add up the group results, i.e. 6 for group 1,
and check it against a countif(group 1) from the original chart?

Question Test.xlsx

[LankyOgre]

I have a second question. I also want to return a list of students who like apples. Is there an easy way to return just that list?

[ChemistB]

Q1: One way, In L2 copied down

=SUM(G2:K2)=COUNTIF($C$3:$C$11, RIGHT(F2,1)+0)
TRUE means they match, False means don't match. If you want it as a CF
=NOT(SUM($G2:$K2)=COUNTIF($C$3:$C$11, RIGHT($F2,1)+0))

Q2
An array formula is a quick way to do this
=IFERROR(INDEX($A$3:$A$11, SMALL(IF($B$3:$B$11=A$13, ROW($A$3:$A$11)-ROW($A$3)+1), ROWS($A$14:$A14))),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

See attachment

[hemesh]

Check attached I used pivot table for this, May be helpful to you.