Highlight most frequent cell values in the row

[Kyrpo]

Hi Excelers Experts,

So... I have a range of columns from B to M filled with words. I'm looking for a macro that in every row looks for the most frequent name and then color the interior of their cell in yellow.

Dario Ita	Dario Ita	Dario Ita	Jack Usa	Simon Usa
Lucas Usa	Frank Uk	Lucas Usa	Frank Uk	Frank Uk
Jack Usa	Joe De	James Irl	James Irl	Louis Fr

<tbody>
</tbody>

I have no idea where to begin and how complicated this might be.
Any hint would be extremely helpful.

Thanks for you helping

Kind regards

 

[mancubus]

hi.

conditional format:

microsoft excel - Conditional Formatting to highlight cells with highest frequency - Super User

 

[ArthriticPanda]

Hi,

You don't need code for this, you could use the following formula using Ctrl+Shift+Enter:

{=INDEX(A1:E1,MODE(MATCH(A1:E1,A1:E1,0)))}

NB: the curly brackets will be added when you use the CSE combo.

AP