The Following rows are manually highlighted based on text value in Column B. I know how to conditional format for duplicates, but I don't know how to conditional format when there is more than one version of duplicates, in alternating sequence, with variable number of rows. is there a way to do this?
| Excel 2010 | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | |||
| 1 | Job # | SCF or NDC Destination | Pieces | A-Date | Delivery Date | Days Late | Early Delivery? Days Early: | Carrier | Notes | Additional Info | Shipments | ||
| 2 | J75008MDU-01 | NDC ATLANTA GA 311 | 6,969 | 7/20/2018 | 7/10/2018 | 8 | A&O | 43301NDC ATLANTA GA 311 | |||||
| 3 | J74827PJC-01 | NDC DALLAS TX 751 | 25,523 | 7/6/2018 | 7/9/2018 | 1 | Not Early | Future Logistics | Delay in Transit | 43287NDC DALLAS TX 751 | |||
| 4 | J74830PJC-01 | NDC DALLAS TX 751 | 10,510 | 7/6/2018 | 7/9/2018 | 1 | Not Early | Future Logistics | Delay in Transit | 43287NDC DALLAS TX 751 | |||
| 5 | J74838PJC-01 | NDC DALLAS TX 751 | 2,002 | 7/6/2018 | 7/9/2018 | 1 | Not Early | Future Logistics | Delay in Transit | 43287NDC DALLAS TX 751 | |||
| 6 | J74839PJC-01 | NDC DALLAS TX 751 | 2,002 | 7/6/2018 | 7/9/2018 | 1 | Not Early | Future Logistics | Delay in Transit | 43287NDC DALLAS TX 751 | |||
| 7 | J74865PJC-01 | NDC DALLAS TX 751 | 18,018 | 7/6/2018 | 7/9/2018 | 1 | Not Early | Future Logistics | Delay in Transit | 43287NDC DALLAS TX 751 | |||
| 8 | J74851PJC-01 | NDC DALLAS TX 751 | 2,002 | 7/6/2018 | 7/11/2018 | 3 | Not Early | Future Logistics | Delay in Transit | 43287NDC DALLAS TX 751 | |||
| 9 | J75313FRA-01 | NDC DES MOINES IA 509 | 1,501 | 8/24/2018 | 8/27/2018 | 1 | Not Early | Future Logistics | Delay in Transit | 43336NDC DES MOINES IA 509 | |||
| 10 | J75315FRA-01 | NDC DES MOINES IA 509 | 1,501 | 8/24/2018 | 8/27/2018 | 1 | Not Early | Future Logistics | Delay in Transit | 43336NDC DES MOINES IA 509 | |||
| 11 | J75316FRA-01 | NDC DES MOINES IA 509 | 1,500 | 8/24/2018 | 8/27/2018 | 1 | Not Early | Future Logistics | Delay in Transit | 43336NDC DES MOINES IA 509 | |||
| 12 | J75320FRA-01 | NDC DES MOINES IA 509 | 1,501 | 8/24/2018 | 8/27/2018 | 1 | Not Early | Future Logistics | Delay in Transit | 43336NDC DES MOINES IA 509 | |||
| 13 | J75101PJC-01 | NDC JAXVILLE FL 320 | 6,007 | 7/27/2018 | 7/30/2018 | 1 | Not Early | Future Logistics | Delay in Transit | 43308NDC JAXVILLE FL 320 | |||
| 14 | J75113PJC-01 | NDC JAXVILLE FL 320 | 2,002 | 7/27/2018 | 7/30/2018 | 1 | Not Early | Future Logistics | Delay in Transit | 43308NDC JAXVILLE FL 320 | |||
| 15 | J74524PJC-01 | NDC JAXVILLE FL 320 | 2,002 | 6/8/2018 | 6/11/2018 | 1 | Not Early | Future Logistics | Delay in Transit | 43259NDC JAXVILLE FL 320 | |||
Sheet1 | |||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| F2 | =IF($E2>=$D2,(NETWORKDAYS($D2+1,$E2)),"") | |
| F3 | =IF($E3>=$D3,(NETWORKDAYS($D3+1,$E3)),"") | |
| F4 | =IF($E4>=$D4,(NETWORKDAYS($D4+1,$E4)),"") | |
| F5 | =IF($E5>=$D5,(NETWORKDAYS($D5+1,$E5)),"") | |
| F6 | =IF($E6>=$D6,(NETWORKDAYS($D6+1,$E6)),"") | |
| F7 | =IF($E7>=$D7,(NETWORKDAYS($D7+1,$E7)),"") | |
| F8 | =IF($E8>=$D8,(NETWORKDAYS($D8+1,$E8)),"") | |
| F9 | =IF($E9>=$D9,(NETWORKDAYS($D9+1,$E9)),"") | |
| F10 | =IF($E10>=$D10,(NETWORKDAYS($D10+1,$E10)),"") | |
| F11 | =IF($E11>=$D11,(NETWORKDAYS($D11+1,$E11)),"") | |
| F12 | =IF($E12>=$D12,(NETWORKDAYS($D12+1,$E12)),"") | |
| F13 | =IF($E13>=$D13,(NETWORKDAYS($D13+1,$E13)),"") | |
| F14 | =IF($E14>=$D14,(NETWORKDAYS($D14+1,$E14)),"") | |
| F15 | =IF($E15>=$D15,(NETWORKDAYS($D15+1,$E15)),"") | |
| G2 | =IF($E2<=$D2,(ABS(NETWORKDAYS($D2,$E2)+1)),"Not Early") | |
| G3 | =IF($E3<=$D3,(ABS(NETWORKDAYS($D3,$E3)+1)),"Not Early") | |
| G4 | =IF($E4<=$D4,(ABS(NETWORKDAYS($D4,$E4)+1)),"Not Early") | |
| G5 | =IF($E5<=$D5,(ABS(NETWORKDAYS($D5,$E5)+1)),"Not Early") | |
| G6 | =IF($E6<=$D6,(ABS(NETWORKDAYS($D6,$E6)+1)),"Not Early") | |
| G7 | =IF($E7<=$D7,(ABS(NETWORKDAYS($D7,$E7)+1)),"Not Early") | |
| G8 | =IF($E8<=$D8,(ABS(NETWORKDAYS($D8,$E8)+1)),"Not Early") | |
| G9 | =IF($E9<=$D9,(ABS(NETWORKDAYS($D9,$E9)+1)),"Not Early") | |
| G10 | =IF($E10<=$D10,(ABS(NETWORKDAYS($D10,$E10)+1)),"Not Early") | |
| G11 | =IF($E11<=$D11,(ABS(NETWORKDAYS($D11,$E11)+1)),"Not Early") | |
| G12 | =IF($E12<=$D12,(ABS(NETWORKDAYS($D12,$E12)+1)),"Not Early") | |
| G13 | =IF($E13<=$D13,(ABS(NETWORKDAYS($D13,$E13)+1)),"Not Early") | |
| G14 | =IF($E14<=$D14,(ABS(NETWORKDAYS($D14,$E14)+1)),"Not Early") | |
| G15 | =IF($E15<=$D15,(ABS(NETWORKDAYS($D15,$E15)+1)),"Not Early") | |
| K2 | =D2&B2 | |
| K3 | =D3&B3 | |
| K4 | =D4&B4 | |
| K5 | =D5&B5 | |
| K6 | =D6&B6 | |
| K7 | =D7&B7 | |
| K8 | =D8&B8 | |
| K9 | =D9&B9 | |
| K10 | =D10&B10 | |
| K11 | =D11&B11 | |
| K12 | =D12&B12 | |
| K13 | =D13&B13 | |
| K14 | =D14&B14 | |
| K15 | =D15&B15 | |
