Conditional formatting

[megabolic]

Hi,

I'm trying to achieve the following : i'm holding a quiz with team1 to team 30. In 1 round you have "vraag 1" till "vraag 20".
A team can get 0, 1 or 2 points per question. What I am trying to do is, when on 1 question (vraag) there is only 1 team with 2 points, this team gets a gold highlight for that question. If only 2 teams have got 2 points, they both
get a silver highlight. If 3 teams get 2 points, these 3 get a bronze highlight. If no team can get 2 point, the cell with the question number should get red.

Can anyone plz help me?

[ChemistB]

Selecting C6:AF25, conditional formatting>new rule> use formula
=AND(C6=2, COUNTIF($C6:$AF6,2)=1) for gold
=AND(C6=2, COUNTIF($C6:$AF6,2)=2) for silver
=AND(C6=2, COUNTIF($C6:$AF6,2)=3) for bronze
Change comma's to semi colons based on local settings.

[reagan.kha]

Please see attached, similar solution to the previous post. If 4 or more teams get 2 points, then no teams get any highlighting.

[protonLeah]

Red (Vraag):

Please Login or Register  to view this content.

applied to column B6:B25

Gold: (C6:AF25):

Please Login or Register  to view this content.

Silver:

Please Login or Register  to view this content.

Bronze:

Please Login or Register  to view this content.