I have a table with three columns

Name, Country and score

The name and score are entered by the user and the country selected from a set drop down list.

Once all the data is entered, I would like is be able to set a macro or formula to display or highlight just the top two results for each country. I just can't figure it out - any help would be appreciated.

Thanks
Paul