Spreadsheet: 752033d1634543198-how-to-highlight-the-first-cell-value-in-a-row-greater-than-another-cell-value-sample-book
Sheet: Sheet1

 | [NAME]
 | 100 |  |  |  |  |  | Week 1 |  |  |  |  |  |  | Week 2 |  |  |  |  |  |  | Week 3 |  |  |  |  |  |  | Week 4 |  |  |  |  |  |  | Week 5 |  |  |  |  |  |  | Week 6 |  |  |  |  |  |  | Week 7 |  |  |  |  |  |  | Week 8 |  |  |  |  |  |  | Week 9 |  |  |  |  |  |  | Week 10 |  |  |  |  |  |  | Week 11 |  |  |  |  |  |  | Week 12 |  |  |  |  |  |  | Week 13 |  |  |  |  |  |  | Week 14 |  |  |  |  |  |  | Week 15 |  |  |  |  |  |  | Week 16 |  |  |  |  |  |  | Week 17 |  |  |  |  |  |  | Week 18 |  |  |  |  |  |  | Week 19 |  |  |  |  |  |  | Week 20
 |  |  |  |  |  |  | Mon | Tue | Wed | Thu | Fri | S | S | Mon | Tue | Wed | Thu | Fri | S | S | Mon | Tue | Wed | Thu | Fri | S | S | Mon | Tue | Wed | Thu | Fri | S | S | Mon | Tue | Wed | Thu | Fri | S | S | Mon | Tue | Wed | Thu | Fri | S | S | Mon | Tue | Wed | Thu | Fri | S | S | Mon | Tue | Wed | Thu | Fri | S | S | Mon | Tue | Wed | Thu | Fri | S | S | Mon | Tue | Wed | Thu | Fri | S | S | Mon | Tue | Wed | Thu | Fri | S | S | Mon | Tue | Wed | Thu | Fri | S | S | Mon | Tue | Wed | Thu | Fri | S | S | Mon | Tue | Wed | Thu | Fri | S | S | Mon | Tue | Wed | Thu | Fri | S | S | Mon | Tue | Wed | Thu | Fri | S | S | Mon | Tue | Wed | Thu | Fri | S | S | Mon | Tue | Wed | Thu | Fri | S | S | Mon | Tue | Wed | Thu | Fri | S | S | Mon | Tue | Wed | Thu | Fri | S | S
 | Team Size
 | 6
 |  |  |  | Basic No's | Full Team
 | Hours / Mins Per Day |  |  |  | Daily
 | 7.4 |  |  |  | Running total
 |  |  |  |  | Per Person
 | Working Days Reqired |  |  |  | Running total
 |  |  |  | Prudent | Current Team |  | 2 | 2 | 2 | 2 | 2 |  |  | 4 | 4 | 4 | 4 | 4 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 3 | 3 | 3 | 3 | 3 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6
 | Time x1 (H/mm) |  |  |  | Efficiency |  | 0.4 | 0.5 | 0.6 | 0.75 | 0.75 |  |  | 0.6 | 0.7 | 0.8 | 0.8 | 0.8 |  |  | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 |  |  | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 |  |  | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 |  |  | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 |  |  | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 |  |  | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 |  |  | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 |  |  | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 |  |  | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 |  |  | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 |  |  | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 |  |  | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 |  |  | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 |  |  | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 |  |  | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 |  |  | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 |  |  | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 |  |  | 0.9 | 0.9 | 0.9 | 0.9 | 0.9
 |  | 1006 |  |  | Daily Output (Hrs)
 |  |  |  |  | Running total (Hrs)
 | Batch (H/mm)
 |  |  |  | Stretched | Current Team |  | 4 | 4 | 4 | 4 | 4 |  |  | 4 | 4 | 4 | 4 | 4 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6 |  |  | 6 | 6 | 6 | 6 | 6
 |  |  |  |  | Efficiency |  | 0.75 | 0.75 | 0.8 | 0.75 | 0.75 |  |  | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 |  |  | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 |  |  | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 |  |  | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 |  |  | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 |  |  | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 |  |  | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 |  |  | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 |  |  | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 |  |  | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 |  |  | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 |  |  | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 |  |  | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 |  |  | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 |  |  | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 |  |  | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 |  |  | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 |  |  | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 |  |  | 0.8 | 0.8 | 0.8 | 0.8 | 0.8
 | Daily Req (H/mm) |  |  |  | Daily Output (Hrs)
 |  |  |  |  | Running total (Hrs)
 | Per Person (H/mm) |  |  | Predicted | Basic Hours
 |  |  |  |  | Prudent
 |  |  |  |  | Stretched
 | Absolute Best
 | 0.9324324324324325 |  |  |  | Completed Daily |  | 0 | 0 | 10 | 1 | 2
 |  |  |  | R.T.