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:
=SUM(LARGE($F$2:$F$8,1),LARGE($F$2:$F$8,2),LARGE($F$2:$F$8,3))
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: