Spreadsheet: 207551d1358490661-advanced-conditional-formatting-possibly-challenging-excel-issue-sample
Sheet: Before

 |  | Needed Outside | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 5
 |  | Needed in Office | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 2 | 1
 |  | Needed Handling Complaints | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Start | Rank |  | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00
Stop | Rank | 4 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00
George | 1 | 1 |  |  |  |  |  |  |  |  | George | George | George | George | George | George | George | George | George | George | George | George
[NAME] | 2 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | 3 | 3 |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | 4 | 4 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | 5 | 5
Martin | 6 | 6 |  |  |  |  |  |  |  |  |  |  | Martin | Martin | Martin | Martin | Martin | Martin | Martin | Martin | Martin | Martin
[NAME] | 7 | 7 |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Zachary | 8 | 8 |  |  |  | Zachary | Zachary | Zachary | Zachary | Zachary | Zachary | Zachary | Zachary | Zachary | Zachary | Zachary | Zachary | Zachary | Zachary | Zachary | Zachary | Zachary
Millard | 9 | 9 |  |  |  | Millard | Millard | Millard | Millard | Millard | Millard | Millard | Millard | Millard | Millard | Millard | Millard | Millard | Millard | Millard | Millard | Millard
Franklin | 10 | 10
[NAME] | 11 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
Ulysses | 12 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ulysses | Ulysses | Ulysses | Ulysses | Ulysses | Ulysses
Rutherford | 13 | 13 | Rutherford | Rutherford | Rutherford | Rutherford | Rutherford | Rutherford | Rutherford | Rutherford | Rutherford | Rutherford | Rutherford | Rutherford | Rutherford | Rutherford | Rutherford | Rutherford | Rutherford
Chester | 14 | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chester | Chester | Chester | Chester
Grover | 15 | 15 |  |  |  |  |  |  |  |  | Grover | Grover | Grover | Grover | Grover | Grover | Grover | Grover | Grover | Grover | Grover | Grover
[NAME] | 16 | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Theodore | 17 | 17 |  |  |  |  | Theodore | Theodore | Theodore | Theodore | Theodore | Theodore | Theodore | Theodore | Theodore | Theodore | Theodore | Theodore | Theodore | Theodore | Theodore | Theodore
Woodrow | 18 | 18 |  |  |  |  |  |  |  |  | Woodrow | Woodrow | Woodrow | Woodrow | Woodrow | Woodrow | Woodrow | Woodrow | Woodrow | Woodrow | Woodrow | Woodrow
[NAME] | 19 | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME]
Calvin | 20 | 20 | Calvin | Calvin | Calvin | Calvin | Calvin | Calvin | Calvin | Calvin | Calvin | Calvin | Calvin | Calvin | Calvin | Calvin | Calvin | Calvin | Calvin
[NAME] | 21 | 21 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | 22 | 22 |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Dwight | 23 | 23 |  |  |  |  |  |  |  |  | Dwight | Dwight | Dwight | Dwight | Dwight | Dwight | Dwight | Dwight | Dwight | Dwight | Dwight | Dwight
Lyndon | 24 | 24 |  |  |  |  |  |  |  |  |  |  | Lyndon | Lyndon | Lyndon | Lyndon | Lyndon | Lyndon | Lyndon | Lyndon | Lyndon | Lyndon
[NAME] | 25 | 25
[NAME] | 26 | 26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] | 27 | 27 |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | 28 | 28
[NAME] | 29 | 29 |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Barack | 30 | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Barack | Barack | Barack | Barack