Spreadsheet: 168875d1342619091-conditional-formatting-formula-question-classiccondformatsample
Sheet: Stone Crossing

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012  ELKS  CLASSIC  -  Stone Crossing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Points + Handicap = Score
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ( Big, Positive Numbers Are Good ) |  |  | 4 | 3 | 4 | 5 | 5 | 4 | 4 | 3 | 4 |  | 4 | 3 | 4 | 5 | 5 | 4 | 4 | 3 | 4
 |  | Hole | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Gross | Pts | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Gross | Pts |  |  | 18 Hole |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Front | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Back
TEAM # 1 |  |  |  |  |  |  |  |  |  |  |  | Front Nine |  |  |  |  |  |  |  |  |  |  | Back Nine |  | Gross | Pts | Hcp | Score
 |  | Team Points
 |  |  | 4 | 5 | 3 | 5 | 6 | 6 | 4 | 4 | 4 |  |  | 3 | 3 | 3 | 6 | 4 | 5 | 4 | 3 | 4
 |  |  | 4 | 4 | 5 | 3 | 5 | 5 | 4 | 6 | 9 |  |  | 5 | 3 | 6 | 7 | 6 | 4 | 6 | 3 | 5
 |  |  | 5 | 7 | 6 | 6 | 6 | 6 | 5 | 6 | 6 |  |  | 5 | 6 | 4 | 6 | 6 | 7 | 6 | 4 | 7
 |  |  | 5 | 5 | 6 | 4 | 6 | 7 | 4 | 5 | 8 |  |  | 7 | 3 | 6 | 8 | 6 | 7 | 6 | 4 | 6
 |  | Par | 4 | 4 | 3 | 5 | 3 | 4 | 4 | 5 | 4 |  |  | 4 | 4 | 3 | 5 | 3 | 4 | 4 | 5 | 4
TEAM # 2 |  |  |  |  |  |  |  |  |  |  |  | Front Nine |  |  |  |  |  |  |  |  |  |  | Back Nine |  | Gross | Pts | Hcp | Score
 |  | Team Points
 |  |  | 4 | 4 | 5 | 6 | 4 | 4 | 4 | 4 | 4 |  |  | 4 | 5 | 3 | 5 | 6 | 6 | 4 | 4 | 4
 |  |  | 6 | 4 | 4 | 8 | 6 | 6 | 5 | 2 | 4 |  |  | 4 | 4 | 5 | 3 | 5 | 5 | 4 | 6 | 9
 |  |  | 6 | 4 | 4 | 7 | 6 | 3 | 8 | 5 | 7 |  |  | 5 | 7 | 6 | 6 | 6 | 6 | 5 | 6 | 6
 |  |  | 5 | 4 | 6 | 7 | 6 | 5 | 6 | 3 | 6 |  |  | 5 | 5 | 6 | 4 | 6 | 7 | 4 | 5 | 8
 |  | Par | 4 | 4 | 3 | 5 | 3 | 4 | 4 | 5 | 4 |  |  | 4 | 4 | 3 | 5 | 3 | 4 | 4 | 5 | 4
TEAM # 3 |  |  |  |  |  |  |  |  |  |  |  | Front Nine |  |  |  |  |  |  |  |  |  |  | Back Nine |  | Gross | Pts | Hcp | Score
 |  | Team Points
 |  |  | 4 | 5 | 3 | 5 | 6 | 6 | 4 | 4 | 4 |  |  | 3 | 3 | 3 | 6 | 4 | 5 | 4 | 3 | 4
 |  |  | 4 | 4 | 5 | 3 | 5 | 5 | 4 | 6 | 9 |  |  | 5 | 3 | 6 | 7 | 6 | 4 | 6 | 3 | 5
 |  |  | 5 | 7 | 6 | 6 | 6 | 6 | 5 | 6 | 6 |  |  | 5 | 6 | 4 | 6 | 6 | 7 | 6 | 4 | 7
 |  |  | 5 | 5 | 6 | 4 | 6 | 7 | 4 | 5 | 8 |  |  | 7 | 3 | 6 | 8 | 6 | 7 | 6 | 4 | 6
 |  | Par | 4 | 4 | 3 | 5 | 3 | 4 | 4 | 5 | 4 |  |  | 4 | 4 | 3 | 5 | 3 | 4 | 4 | 5 | 4
TEAM # 4 |  |  |  |  |  |  |  |  |  |  |  | Front Nine |  |  |  |  |  |  |  |  |  |  | Back Nine |  | Gross | Pts | Hcp | Score
 |  | Team Points
 |  |  | 3 | 3 | 3 | 6 | 4 | 5 | 4 | 3 | 4 |  |  | 4 | 4 | 5 | 6 | 4 | 4 | 4 | 4 | 4
 |  |  | 5 | 3 | 6 | 7 | 6 | 4 | 6 | 3 | 5 |  |  | 6 | 4 | 4 | 8 | 6 | 6 | 5 | 2 | 4
 |  |  | 5 | 6 | 4 | 6 | 6 | 7 | 6 | 4 | 7 |  |  | 6 | 4 | 4 | 7 | 6 | 3 | 8 | 5 | 7
 |  |  | 7 | 3 | 6 | 8 | 6 | 7 | 6 | 4 | 6 |  |  | 5 | 4 | 6 | 7 | 6 | 5 | 6 | 3 | 6
 |  | Par | 4 | 4 | 3 | 5 | 3 | 4 | 4 | 5 | 4 |  |  | 4 | 4 | 3 | 5 | 3 | 4 | 4 | 5 | 4
TEAM # 5 |  |  |  |  |  |  |  |  |  |  |  | Front Nine |  |  |  |  |  |  |  |  |  |  | Back Nine |  | Gross | Pts | Hcp | Score
 |  | Team Points
 |  |  | 4 | 4 | 5 | 6 | 4 | 4 | 4 | 4 | 4 |  |  | 3 | 3 | 3 | 6 | 4 | 5 | 4 | 3 | 4
 |  |  | 6 | 4 | 4 | 8 | 6 | 6 | 5 | 2 | 4 |  |  | 5 | 3 | 6 | 7 | 6 | 4 | 6 | 3 | 5
 |  |  | 6 | 4 | 4 | 7 | 6 | 3 | 8 | 5 | 7 |  |  | 5 | 6 | 4 | 6 | 6 | 7 | 6 | 4 | 7
 |  |  | 5 | 4 | 6 | 7 | 6 | 5 | 6 | 3 | 6 |  |  | 7 | 3 | 6 | 8 | 6 | 7 | 6 | 4 | 6
 |  | Par | 4 | 4 | 3 | 5 | 3 | 4 | 4 | 5 | 4 |  |  | 4 | 4 | 3 | 5 | 3 | 4 | 4 | 5 | 4
TEAM # 6 |  |  |  |  |  |  |  |  |  |  |  | Front Nine |  |  |  |  |  |  |  |  |  |  | Back Nine |  | Gross | Pts | Hcp | Score
 |  | Team Points
 |  |  | 3 | 3 | 3 | 6 | 4 | 5 | 4 | 3 | 4 |  |  | 4 | 4 | 5 | 6 | 4 | 4 | 4 | 4 | 4
 |  |  | 5 | 3 | 6 | 7 | 6 | 4 | 6 | 3 | 5 |  |  | 6 | 4 | 4 | 8 | 6 | 6 | 5 | 2 | 4
 |  |  | 5 | 6 | 4 | 6 | 6 | 7 | 6 | 4 | 7 |  |  | 6 | 4 | 4 | 7 | 6 | 3 | 8 | 5 | 7
 |  |  | 7 | 3 | 6 | 8 | 6 | 7 | 6 | 4 | 6 |  |  | 5 | 4 | 6 | 7 | 6 | 5 | 6 | 3 | 6
 |  | Par | 4 | 4 | 3 | 5 | 3 | 4 | 4 | 5 | 4 |  |  | 4 | 4 | 3 | 5 | 3 | 4 | 4 | 5 | 4
TEAM # 7 |  |  |  |  |  |  |  |  |  |  |  | Front Nine |  |  |  |  |  |  |  |  |  |  | Back Nine |  | Gross | Pts | Hcp | Score
 |  | Team Points
 |  |  | 4 | 5 | 3 | 5 | 6 | 6 | 4 | 4 | 4 |  |  | 3 | 3 | 3 | 6 | 4 | 5 | 4 | 3 | 4
 |  |  | 4 | 4 | 5 | 3 | 5 | 5 | 4 | 6 | 9 |  |  | 5 | 3 | 6 | 7 | 6 | 4 | 6 | 3 | 5
 |  |  | 5 | 7 | 6 | 6 | 6 | 6 | 5 | 6 | 6 |  |  | 5 | 6 | 4 | 6 | 6 | 7 | 6 | 4 | 7
 |  |  | 5 | 5 | 6 | 4 | 6 | 7 | 4 | 5 | 8 |  |  | 7 | 3 | 6 | 8 | 6 | 7 | 6 | 4 | 6
TEAM # 8 |  |  |  |  |  |  |  |  |  |  |  | Front Nine |  |  |  |  |  |  |  |  |  |  | Back Nine |  | Gross | Pts | Hcp | Score
 |  | Team Points
 |  |  | 3 | 3 | 3 | 6 | 4 | 5 | 4 | 3 | 4 |  |  | 4 | 5 | 3 | 5 | 6 | 6 | 4 | 4 | 4
 |  |  | 5 | 3 | 6 | 7 | 6 | 4 | 6 | 3 | 5 |  |  | 4 | 4 | 5 | 3 | 5 | 5 | 4 | 6 | 9
 |  |  | 5 | 6 | 4 | 6 | 6 | 7 | 6 | 4 | 7 |  |  | 5 | 7 | 6 | 6 | 6 | 6 | 5 | 6 | 6
 |  |  | 7 | 3 | 6 | 8 | 6 | 7 | 6 | 4 | 6 |  |  | 5 | 5 | 6 | 4 | 6 | 7 | 4 | 5 | 8
 |  | Par | 4 | 4 | 3 | 5 | 3 | 4 | 4 | 5 | 4 |  |  | 4 | 4 | 3 | 5 | 3 | 4 | 4 | 5 | 4
TEAM # 9 |  |  |  |  |  |  |  |  |  |  |  | Front Nine |  |  |  |  |  |  |  |  |  |  | Back Nine |  | Gross | Pts | Hcp | Score
 |  | Team Points
 |  |  | 4 | 4 | 5 | 6 | 4 | 4 | 4 | 4 | 4 |  |  | 3 | 3 | 3 | 6 | 4 | 5 | 4 | 3 | 4
 |  |  | 6 | 4 | 4 | 8 | 6 | 6 | 5 | 2 | 4 |  |  | 5 | 3 | 6 | 7 | 6 | 4 | 6 | 3 | 5
 |  |  | 6 | 4 | 4 | 7 | 6 | 3 | 8 | 5 | 7 |  |  | 5 | 6 | 4 | 6 | 6 | 7 | 6 | 4 | 7
 |  |  | 5 | 4 | 6 | 7 | 6 | 5 | 6 | 3 | 6 |  |  | 7 | 3 | 6 | 8 | 6 | 7 | 6 | 4 | 6
 |  | Par | 4 | 4 | 3 | 5 | 3 | 4 | 4 | 5 | 4 |  |  | 4 | 4 | 3 | 5 | 3 | 4 | 4 | 5 | 4
TEAM # 10 |  |  |  |  |  |  |  |  |  |  |  | Front Nine |  |  |  |  |  |  |  |  |  |  | Back Nine |  | Gross | Pts | Hcp | Score
 |  | Team Points
 |  |  | 3 | 3 | 3 | 6 | 4 | 5 | 4 | 3 | 4 |  |  | 4 | 5 | 3 | 5 | 6 | 6 | 4 | 4 | 4
 |  |  | 5 | 3 | 6 | 7 | 6 | 4 | 6 | 3 | 5 |  |  | 4 | 4 | 5 | 3 | 5 | 5 | 4 | 6 | 9
 |  |  | 5 | 6 | 4 | 6 | 6 | 7 | 6 | 4 | 7 |  |  | 5 | 7 | 6 | 6 | 6 | 6 | 5 | 6 | 6
 |  |  | 7 | 3 | 6 | 8 | 6 | 7 | 6 | 4 | 6 |  |  | 5 | 5 | 6 | 4 | 6 | 7 | 4 | 5 | 8
 |  | Par | 4 | 4 | 3 | 5 | 3 | 4 | 4 | 5 | 4 |  |  | 4 | 4 | 3 | 5 | 3 | 4 | 4 | 5 | 4
TEAM # 11 |  |  |  |  |  |  |  |  |  |  |  | Front Nine |  |  |  |  |  |  |  |  |  |  | Back Nine |  | Gross | Pts | Hcp | Score
 |  | Team Points
 |  |  | 4 | 5 | 3 | 5 | 6 | 6 | 4 | 4 | 4 |  |  | 4 | 4 | 5 | 6 | 4 | 4 | 4 | 4 | 4
 |  |  | 4 | 4 | 5 | 3 | 5 | 5 | 4 | 6 | 9 |  |  | 6 | 4 | 4 | 8 | 6 | 6 | 5 | 2 | 4
 |  |  | 5 | 7 | 6 | 6 | 6 | 6 | 5 | 6 | 6 |  |  | 6 | 4 | 4 | 7 | 6 | 3 | 8 | 5 | 7
 |  |  | 5 | 5 | 6 | 4 | 6 | 7 | 4 | 5 | 8 |  |  | 5 | 4 | 6 | 7 | 6 | 5 | 6 | 3 | 6
 |  | Par | 4 | 4 | 3 | 5 | 3 | 4 | 4 | 5 | 4 |  |  | 4 | 4 | 3 | 5 | 3 | 4 | 4 | 5 | 4
TEAM # 12 |  |  |  |  |  |  |  |  |  |  |  | Front Nine |  |  |  |  |  |  |  |  |  |  | Back Nine |  | Gross | Pts | Hcp | Score
 |  | Team Points
 |  |  | 3 | 3 | 3 | 6 | 4 | 5 | 4 | 3 | 4 |  |  | 4 | 5 | 3 | 5 | 6 | 6 | 4 | 4 | 4
 |  |  | 5 | 3 | 6 | 7 | 6 | 4 | 6 | 3 | 5 |  |  | 4 | 4 | 5 | 3 | 5 | 5 | 4 | 6 | 9
 |  |  | 5 | 6 | 4 | 6 | 6 | 7 | 6 | 4 | 7 |  |  | 5 | 7 | 6 | 6 | 6 | 6 | 5 | 6 | 6
 |  |  | 7 | 3 | 6 | 8 | 6 | 7 | 6 | 4 | 6 |  |  | 5 | 5 | 6 | 4 | 6 | 7 | 4 | 5 | 8
 |  | Par | 4 | 4 | 3 | 5 | 3 | 4 | 4 | 5 | 4 |  |  | 4 | 4 | 3 | 5 | 3 | 4 | 4 | 5 | 4
TEAM # 13 |  |  |  |  |  |  |  |  |  |  |  | Front Nine |  |  |  |  |  |  |  |  |  |  | Back Nine |  | Gross | Pts | Hcp | Score
 |  | Team Points
 |  |  | 4 | 4 | 5 | 6 | 4 | 4 | 4 | 4 | 4 |  |  | 3 | 3 | 3 | 6 | 4 | 5 | 4 | 3 | 4
 |  |  | 6 | 4 | 4 | 8 | 6 | 6 | 5 | 2 | 4 |  |  | 5 | 3 | 6 | 7 | 6 | 4 | 6 | 3 | 5
 |  |  | 6 | 4 | 4 | 7 | 6 | 3 | 8 | 5 | 7 |  |  | 5 | 6 | 4 | 6 | 6 | 7 | 6 | 4 | 7
 |  |  | 5 | 4 | 6 | 7 | 6 | 5 | 6 | 3 | 6 |  |  | 7 | 3 | 6 | 8 | 6 | 7 | 6 | 4 | 6
 |  | Par | 4 | 4 | 3 | 5 | 3 | 4 | 4 | 5 | 4 |  |  | 4 | 4 | 3 | 5 | 3 | 4 | 4 | 5 | 4
TEAM # 14 |  |  |  |  |  |  |  |  |  |  |  | Front Nine |  |  |  |  |  |  |  |  |  |  | Back Nine |  | Gross | Pts | Hcp | Score
 |  | Team Points
 |  |  | 3 | 3 | 3 | 6 | 4 | 5 | 4 | 3 | 4 |  |  | 4 | 5 | 3 | 5 | 6 | 6 | 4 | 4 | 4
 |  |  | 5 | 3 | 6 | 7 | 6 | 4 | 6 | 3 | 5 |  |  | 4 | 4 | 5 | 3 | 5 | 5 | 4 | 6 | 9
 |  |  | 5 | 6 | 4 | 6 | 6 | 7 | 6 | 4 | 7 |  |  | 5 | 7 | 6 | 6 | 6 | 6 | 5 | 6 | 6
 |  |  | 7 | 3 | 6 | 8 | 6 | 7 | 6 | 4 | 6 |  |  | 5 | 5 | 6 | 4 | 6 | 7 | 4 | 5 | 8
 |  | Par | 4 | 4 | 3 | 5 | 3 | 4 | 4 | 5 | 4 |  |  | 4 | 4 | 3 | 5 | 3 | 4 | 4 | 5 | 4 |  |  |  |  |  |  | ( Big, Positive Numbers Are Good ) | Delete Row Repeat |  | 4 | 3 | 4 | 5 | 5 | 4 | 4 | 3 | 4 |  | 4 | 3 | 4 | 5 | 5 | 4 | 4 | 3 | 4
TEAM # 15 |  |  |  |  |  |  |  |  |  |  |  | Front Nine |  |  |  |  |  |  |  |  |  |  | Back Nine |  | Gross | Pts | Hcp | Score |  | A108:AD165
 |  | Team Points
 |  |  | 4 | 5 | 3 | 5 | 6 | 6 | 4 | 4 | 4 |  |  | 4 | 4 | 5 | 6 | 4 | 4 | 4 | 4 | 4
 |  |  | 4 | 4 | 5 | 3 | 5 | 5 | 4 | 6 | 9 |  |  | 6 | 4 | 4 | 8 | 6 | 6 | 5 | 2 | 4
 |  |  | 5 | 7 | 6 | 6 | 6 | 6 | 5 | 6 | 6 |  |  | 6 | 4 | 4 | 7 | 6 | 3 | 8 | 5 | 7
 |  |  | 5 | 5 | 6 | 4 | 6 | 7 | 4 | 5 | 8 |  |  | 5 | 4 | 6 | 7 | 6 | 5 | 6 | 3 | 6
TEAM # 16 |  |  |  |  |  |  |  |  |  |  |  | Front Nine |  |  |  |  |  |  |  |  |  |  | Back Nine |  | Gross | Pts | Hcp | Score
 |  | Team Points
 |  |  | 3 | 3 | 3 | 6 | 4 | 5 | 4 | 3 | 4 |  |  | 4 | 5 | 3 | 5 | 6 | 6 | 4 | 4 | 4
 |  |  | 5 | 3 | 6 | 7 | 6 | 4 | 6 | 3 | 5 |  |  | 4 | 4 | 5 | 3 | 5 | 5 | 4 | 6 | 9
 |  |  | 5 | 6 | 4 | 6 | 6 | 7 | 6 | 4 | 7 |  |  | 5 | 7 | 6 | 6 | 6 | 6 | 5 | 6 | 6
 |  |  | 7 | 3 | 6 | 8 | 6 | 7 | 6 | 4 | 6 |  |  | 5 | 5 | 6 | 4 | 6 | 7 | 4 | 5 | 8
TEAM # 17 |  |  |  |  |  |  |  |  |  |  |  | Front Nine |  |  |  |  |  |  |  |  |  |  | Back Nine |  | Gross | Pts | Hcp | Score
 |  | Team Points
 |  |  | 4 | 5 | 3 | 5 | 6 | 6 | 4 | 4 | 4 |  |  | 3 | 3 | 3 | 6 | 4 | 5 | 4 | 3 | 4
 |  |  | 4 | 4 | 5 | 3 | 5 | 5 | 4 | 6 | 9 |  |  | 5 | 3 | 6 | 7 | 6 | 4 | 6 | 3 | 5
 |  |  | 5 | 7 | 6 | 6 | 6 | 6 | 5 | 6 | 6 |  |  | 5 | 6 | 4 | 6 | 6 | 7 | 6 | 4 | 7
 |  |  | 5 | 5 | 6 | 4 | 6 | 7 | 4 | 5 | 8 |  |  | 7 | 3 | 6 | 8 | 6 | 7 | 6 | 4 | 6
TEAM # 18 |  |  |  |  |  |  |  |  |  |  |  | Front Nine |  |  |  |  |  |  |  |  |  |  | Back Nine |  | Gross | Pts | Hcp | Score
 |  | Team Points
 |  |  | 3 | 3 | 3 | 6 | 4 | 5 | 4 | 3 | 4 |  |  | 4 | 4 | 5 | 6 | 4 | 4 | 4 | 4 | 4
 |  |  | 5 | 3 | 6 | 7 | 6 | 4 | 6 | 3 | 5 |  |  | 6 | 4 | 4 | 8 | 6 | 6 | 5 | 2 | 4
 |  |  | 5 | 6 | 4 | 6 | 6 | 7 | 6 | 4 | 7 |  |  | 6 | 4 | 4 | 7 | 6 | 3 | 8 | 5 | 7
 |  |  | 7 | 3 | 6 | 8 | 6 | 7 | 6 | 4 | 6 |  |  | 5 | 4 | 6 | 7 | 6 | 5 | 6 | 3 | 6
TEAM # 19 |  |  |  |  |  |  |  |  |  |  |  | Front Nine |  |  |  |  |  |  |  |  |  |  | Back Nine |  | Gross | Pts | Hcp | Score
 |  | Team Points
 |  |  | 4 | 5 | 3 | 5 | 6 | 6 | 4 | 4 | 4 |  |  | 3 | 3 | 3 | 6 | 4 | 5 | 4 | 3 | 4
 |  |  | 4 | 4 | 5 | 3 | 5 | 5 | 4 | 6 | 9 |  |  | 5 | 3 | 6 | 7 | 6 | 4 | 6 | 3 | 5
 |  |  | 5 | 7 | 6 | 6 | 6 | 6 | 5 | 6 | 6 |  |  | 5 | 6 | 4 | 6 | 6 | 7 | 6 | 4 | 7
 |  |  | 5 | 5 | 6 | 4 | 6 | 7 | 4 | 5 | 8 |  |  | 7 | 3 | 6 | 8 | 6 | 7 | 6 | 4 | 6
TEAM # 20 |  |  |  |  |  |  |  |  |  |  |  | Front Nine |  |  |  |  |  |  |  |  |  |  | Back Nine |  | Gross | Pts | Hcp | Score
 |  | Team Points
 |  |  | 4 | 4 | 5 | 6 | 4 | 4 | 4 | 4 | 4 |  |  | 4 | 5 | 3 | 5 | 6 | 6 | 4 | 4 | 4
 |  |  | 6 | 4 | 4 | 8 | 6 | 6 | 5 | 2 | 4 |  |  | 4 | 4 | 5 | 3 | 5 | 5 | 4 | 6 | 9
 |  |  | 6 | 4 | 4 | 7 | 6 | 3 | 8 | 5 | 7 |  |  | 5 | 7 | 6 | 6 | 6 | 6 | 5 | 6 | 6
 |  |  | 5 | 4 | 6 | 7 | 6 | 5 | 6 | 3 | 6 |  |  | 5 | 5 | 6 | 4 | 6 | 7 | 4 | 5 | 8