Check if Teams pick a name as representative & agree on a name

[VinceDra]

Hello

Can anyone help me with a formula or a VBA script ?

There are 4 columns with many possible choices (Alice,Bob,Clarisse,Denis,Ernest...). The whole idea is to let 4 teams (columns) to pick a name as representative and check if they do agree on a name or not.

I would like to count the number of name and return a color:
- For instance, if in a row, there are 4 "Alice" or 3 "Alice", it should return green color cell
- IF there are only 2 "Alice", it returns orange color cell
- To finish with, if a row contains less that one "Alice", it will return a red color cell.

I tried some formulas with "IF" and "CountIF", but cannot apply it to the whole sheet since the names are all different (mostly names).



The colored cell goes to the corresponding row from the table "Result"

Thanks in advance