Spreadsheet: 121960d1316528040-how-to-create-conditional-formatting-to-identify-like-numbers-file-for-help-with-2
Sheet: Sheet1

Input name of cell |  | Personnel | 1 |  |  |  | Personnel | 1 |  |  |  | Personnel | 1 |  |  |  | Personnel | 1 |  |  |  | Personnel | 1 |  |  |  | Personnel | 1 |  |  |  | Personnel | 1 |  |  |  | Personnel | 1 |  |  |  | Personnel | 1 |  |  |  | Personnel | 1
Wednesday |  |  |  | 2 | Thursday |  |  |  | 2 | Friday |  |  |  | 0 | Monday |  |  |  | 0 | Tuesday |  |  |  | 0 | Wednesday |  |  |  | 0 | Thursday |  |  |  | 0 | Friday |  |  |  | 0 | Monday |  |  |  | 0 | Tuesday |  |  |  | 0
2011-08-10 00:00:00 |  |  |  |  | 2011-08-11 00:00:00 |  |  |  |  | 2011-08-12 00:00:00 |  |  |  |  | 2011-08-15 00:00:00 |  |  |  |  | 2011-08-16 00:00:00 |  |  |  |  | 2011-08-17 00:00:00 |  |  |  |  | 2011-08-18 00:00:00 |  |  |  |  | 2011-08-19 00:00:00 |  |  |  |  | 2011-08-22 00:00:00 |  |  |  |  | 2011-08-23 00:00:00
shop floor order | Part Number | Qty | Run Time | [NAME] | shop floor order | Part Number | Qty | Run Time | [NAME] | shop floor order | Part Number | Qty | Run Time | [NAME] | shop floor order | Part Number | Qty | Run Time | [NAME] | shop floor order | Part Number | Qty | Run Time | [NAME] | shop floor order | Part Number | Qty | Run Time | [NAME] | shop floor order | Part Number | Qty | Run Time | [NAME] | shop floor order | Part Number | Qty | Run Time | [NAME] | shop floor order | Part Number | Qty | Run Time | [NAME] | shop floor order | Part Number | Qty | Run Time | [NAME]
490175-000 | 100 | 500 | 1 |  | ST9044-000 | 122 | 500 | 1
490175-000 | 100 | 500 | 4.24 |  | ST9044-000 | 211 | 500 | 1
Shift Length | Total run time |  | 5.24 |  | Shift Length | Total run time |  | 2 |  | Shift Length | Total run time |  | 0 |  | Shift Length | Total run time |  | 0 |  | Shift Length | Total run time |  | 0 |  | Shift Length | Total run time |  | 0 |  | Shift Length | Total run time |  | 0 |  | Shift Length | Total run time |  | 0 |  | Shift Length | Total run time |  | 0 |  | Shift Length | Total run time |  | 0
7.5 | Available labor time |  | 7.5 |  | 7.5 | Available labor time |  | 7.5 |  | 7.5 | Available labor time |  | 7.5 |  | 7.5 | Available labor time |  | 7.5 |  | 7.5 | Available labor time |  | 7.5 |  | 7.5 | Available labor time |  | 7.5 |  | 7.5 | Available labor time |  | 7.5 |  | 7.5 | Available labor time |  | 7.5 |  | 7.5 | Available labor time |  | 7.5 |  | 7.5 | Available labor time |  | 7.5
0 | Net run time available |  | 2.26 |  | 0 | Net run time available |  | 5.5 |  | 0 | Net run time available |  | 7.5 |  | 0 | Net run time available |  | 7.5 |  | 0 | Net run time available |  | 7.5 |  | 0 | Net run time available |  | 7.5 |  | 0 | Net run time available |  | 7.5 |  | 0 | Net run time available |  | 7.5 |  | 0 | Net run time available |  | 7.5 |  | 0 | Net run time available |  | 7.5
 | If green cut labor |  |  |  |  | If green cut labor |  |  |  |  | If green cut labor |  |  |  |  | If green cut labor |  |  |  |  | If green cut labor |  |  |  |  | If green cut labor |  |  |  |  | If green cut labor |  |  |  |  | If green cut labor |  |  |  |  | If green cut labor |  |  |  |  | If green cut labor
 | If red add labor |  |  |  |  | If red add labor |  |  |  |  | If red add labor |  |  |  |  | If red add labor |  |  |  |  | If red add labor |  |  |  |  | If red add labor |  |  |  |  | If red add labor |  |  |  |  | If red add labor |  |  |  |  | If red add labor |  |  |  |  | If red add labor