I have a column of numbers as shown below and need to highlight the 1st through 3rd place scores in red and the 4th through 6th place scores in yellow. I am using a formula with conditional formatting to accomplish this. However, the formula is viewing the scores of 89 as a tie and counting them as 5th and 6th place. I want both scores of 89 to be 5th place and the score of 88 to be 6th place.
100
95
94
93
89
89
88
87
This is the formula I'm using for first place. I have a similar rule for 2nd through 6th.
=LARGE($A$1:$A$25,1)
Thanks for your help!
Bookmarks