Spreadsheet: 168875d1342619091-conditional-formatting-formula-question-classiccondformatsample
Sheet: Drawing Lineup

 |  |  |  |  |  |  |  |  |  | 2012  ELKS  CLASSIC
 |  |  |  |  | AM  Group |  |  |  |  |  |  |  |  |  | PM  Group
 | # 1 |  | Tee Time   8:00 |  |  | # 7 |  | Tee Time   9:00 |  |  | # 11 |  | Tee Time   11:30 |  |  | # 17 |  | Tee Time   12:30
 | 1- |  | 1 |  |  | 1- |  | 7 |  |  | 1- |  | 11 |  |  | 1- |  | 17
 | 2- |  | 1 |  |  | 2- |  | 7 |  |  | 2- |  | 11 |  |  | 2- |  | 17
 | 3- |  | 1 |  |  | 3- |  | 7 |  |  | 3- |  | 11 |  |  | 3- |  | 17
 | 4- |  | 1 |  |  | 4- |  | 7 |  |  | 4- |  | 11 |  |  | 4- |  | 17
 | Scorer: |  |  |  |  | Scorer: |  |  |  |  | Scorer: |  |  |  |  | Scorer:
 | Buyer: |  |  |  |  | Buyer: |  |  |  |  | Buyer: |  |  |  |  | Buyer:
 | # 2 |  | Tee Time   8:10 |  |  | # 8 |  | Tee Time   9:10 |  |  | # 12 |  | Tee Time   11:40 |  |  | # 18 |  | Tee Time   12:40
 | 1- |  | 2 |  |  | 1- |  | 8 |  |  | 1- |  | 12 |  |  | 1- |  | 18
 | 2- |  | 2 |  |  | 2- |  | 8 |  |  | 2- |  | 12 |  |  | 2- |  | 18
 | 3- |  | 2 |  |  | 3- |  | 8 |  |  | 3- |  | 12 |  |  | 3- |  | 18
 | 4- |  | 2 |  |  | 4- |  | 8 |  |  | 4- |  | 12 |  |  | 4- |  | 18
 | Scorer: |  |  |  |  | Scorer: |  |  |  |  | Scorer: |  |  |  |  | Scorer:
 | Buyer: |  |  |  |  | Buyer: |  |  |  |  | Buyer: |  |  |  |  | Buyer:
 | # 3 |  | Tee Time   8:20 |  |  | # 9 |  | Tee Time   9: 20 |  |  | # 13 |  | Tee Time   11:50 |  |  | # 19 |  | Tee Time   12:50
 | 1- |  | 3 |  |  | 1- |  | 9 |  |  | 1- |  | 13 |  |  | 1- |  | 19
 | 2- |  | 3 |  |  | 2- |  | 9 |  |  | 2- |  | 13 |  |  | 2- |  | 19
 | 3- |  | 3 |  |  | 3- |  | 9 |  |  | 3- |  | 13 |  |  | 3- |  | 19
 | 4- |  | 3 |  |  | 4- |  | 9 |  |  | 4- |  | 13 |  |  | 4- |  | 19
 | Scorer: |  |  |  |  | Scorer: |  |  |  |  | Scorer: |  |  |  |  | Scorer:
 | Buyer: |  |  |  |  | Buyer: |  |  |  |  | Buyer: |  |  |  |  | Buyer:
 | # 4 |  | Tee Time   8:30 |  |  | # 10 |  | Tee Time   9:30 |  |  | # 14 |  | Tee Time   12:00 |  |  | # 20 |  | Tee Time   1:00
 | 1- |  | 4 |  |  | 1- |  | 10 |  |  | 1- |  | 14 |  |  | 1- |  | 20
 | 2- |  | 4 |  |  | 2- |  | 10 |  |  | 2- |  | 14 |  |  | 2- |  | 20
 | 3- |  | 4 |  |  | 3- |  | 10 |  |  | 3- |  | 14 |  |  | 3- |  | 20
 | 4- |  | 4 |  |  | 4- |  | 10 |  |  | 4- |  | 14 |  |  | 4- |  | 20
 | Scorer: |  |  |  |  | Scorer: |  |  |  |  | Scorer: |  |  |  |  | Scorer:
 | Buyer: |  |  |  |  | Buyer: |  |  |  |  | Buyer: |  |  |  |  | Buyer:
 | # 5 |  | Tee Time   8:40 |  |  |  |  |  |  |  | # 15 |  | Tee Time   12:10
 | 1- |  | 5 |  |  |  |  |  |  |  | 1- |  | 15
 | 2- |  | 5 |  |  |  |  |  |  |  | 2- |  | 15
 | 3- |  | 5 |  |  |  |  |  |  |  | 3- |  | 15
 | 4- |  | 5 |  |  |  |  |  |  |  | 4- |  | 15
 | Scorer: |  |  |  |  |  |  |  |  |  | Scorer:
 | Buyer: |  |  |  |  |  |  |  |  |  | Buyer:
 | # 6 |  | Tee Time   8:50 |  |  | The Game: |  |  |  |  | # 16 |  | Tee Time   12:20
 | 1- |  | 6 |  |  |  |  | Team With Highest |  |  | 1- |  | 16
 | 2- |  | 6 |  |  |  |  |  | Score Wins.   Where |  | 2- |  | 16
 | 3- |  | 6 |  |  | Score = Handicap + Points. |  |  |  |  | 3- |  | 16
 | 4- |  | 6 |  |  |  |  |  |  |  | 4- |  | 16
 | Scorer: |  |  |  |  | Player Points Are: |  |  |  |  | Scorer:
 | Buyer: |  |  |  |  |  |  |  |  |  | Buyer:
 |  |  |  |  |  | Above Bogey = 0
 |  |  |  |  |  | Bogey = 1 |  |  |  | Purse |  |  |  |  |  | EVENTS  SCHEDULE
 | [NAME]: |  |  |  |  | Par = 2
 |  |  |  |  |  | [NAME] = 3 |  |  |  |  |  |  |  |  |  | Steak Fry -
 |  |  |  |  |  | Eagle = 5
 |  |  |  |  |  | Double Eagle = 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Scorekeepers:
 |  |  |  |  |  |  |  | Captains & Scorekeepers Meet -
 | Pari-mutuel:
 | Auctioneer: |  |  |  |  |  |  | Hamburger Cookout: |  |  |  |  |  |  |  | [NAME]
 | Starter & Skins: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 2nd Day
 | Master [NAME]: |  |  |  |  |  |  | [NAME]:
 |  |  |  |  |  |  |  | Corn: