Top three values using conditional formatting without ties.

[kprusko]

I have a grade book in which I drop the two lowest scores out of five using the following formula.
=ROUND((SUM(C7:G7,-SMALL(C7:G7,{1,2})))/MAX(1,COUNT(C7:G7)-2),1)

I want to show the students which values are being calculated. I used Conditional Formatting in Excel 2011MAC to show the top three value, the problem is the formatting show ties. Is there a way just to show the top three values without ties?

[JieJenn]

See attached.

[kprusko]

Perfect! Thanks!

[kosteraku]

Hey, is it possible to make this file downloadable again?

[JeteMc]

Hello kosteraku and Welcome to Excel Forum.
Assuming that you are inquiring as to the file in post #2, I just downloaded it without any issues.
If you are having issues it may be that your privacy settings/firewall is blocking the download.
Let us know if you have any questions.