Highlight winners in a list.

I have a list of golf scores.

Is there a way to say if a score is the highest in a column then hightlight the column or write 1st next to it. and then 2nd 3rd and so on.

I have tried using filters but thats not quite what i want.

Anyone help?

Thanks
Sam

Have a look at the RANK formula.