First I created a table to let Excel know what the order of your ranking is.
Then I used VLOOKUP to retreive the ranks order.
Formula: =VLOOKUP($B1,$D$1:$E$11,2)>VLOOKUP($A1,$D$1:$E$11,2) Applied range: =$B:$B
Keep in mind that the rankings table can be placed anywhere (i.e. out of sight, different sheet)