Microsoft Excel - Conditional format by formula

Asked By Gauss on 25-Dec-14 02:17 AM
In excel sheet:
Col A   Col B
A       20
B      40
C      30
A       60
B      10
Without additional column I want a formula to use in the conditional format which will color the top two items(A & B) with highest score in column B.

Thank you for your inputs.
Harry Boughen replied to Gauss on 25-Dec-14 03:16 PM
Hello Gauss,
Use this formula in your conditional formatting rule.

=RANK(B2,$B$2:$B$6,0) <= 2

Regards

Harry