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:
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:
No comments:
Post a Comment