Tuesday, February 14, 2012

yogi_Sum Top N Numbers And Highlight The Top N Numbers

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

user Squarky:
I was impressed by your last answer so I have one final questions regarding this gymnastics spreadsheet. On each sheet I have the following formula:
For each event it takes the 3 highest scores from the team in a column and averages them. Is there any way in google docs to change the background color (highlight) those 3 highest score cells?
following is a solution to the problem: