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