Excel help

[Jordan97]

I'm thick as **** in Excel

I'm trying to create a league table, but I need the players to be sorted in order of their points, with the highest at the top, and lowest at the bottom.

I also want the top two players to be highlighted in green.

Can somebody show me how I could do this please?

 

[spydermixx]

Assuming points are in column C from row 5 to 30:

Conditional format using the formula:

=$C5>=LARGE($C$5:$C$30,2)

and then sort the column by descending.