steve400243
Active Member
- Joined
- Sep 15, 2016
- Messages
- 429
- Office Version
- 365
- 2016
- Platform
- Windows
Hello, I need to get the best way to have the attached update the Status Column from NOT AVAILABLE, To AVAILABLE, and to COMPLETE. Once the 4 Needed Documents( Columns H, I, J, K) are all entered in the Status would change to AVAILABLE. And be Green, Would be red and Not Available until then. After all columns are used in the row Status would change to Complete and be Purple. This could have several Housebills. I have 3 listed for reference. Thanks in advance.
TEST SHEET.xlsx | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |||
1 | Vessel: | Container: | Master Bill: | |||||||||||||||
2 | APL QINGDAO | OOLU123456789 | COSU6363636363 | |||||||||||||||
3 | ||||||||||||||||||
4 | Packet Received: | ETA Date: | Container Released: | Container Received | Devanned On: | Storage 7th Day: | Storage 12th Day: | |||||||||||
5 | 1-Sep-2021 | 1-Sep-2021 | 3-Sep-2021 | 3-Sep-2021 | 3-Sep-2021 | 9-Sep-2021 | 14-Sep-2021 | |||||||||||
6 | ||||||||||||||||||
7 | Housebill: | Status: | Office: | Customer: | Mode: | Cartons: | CBM: | Customs Release: | OBL Notification: | Entry: | DO Received: | Pickup Date: | Released to: | PRO: | Shipper PLTS | WHSE PLTS | ||
8 | ABCD123456789 | AVAILABLE | SEA | ABC CORP | FMM | 15 | 10.5 | 4-Sep | 4-Sep | 799-12345678 | 4-Sep | |||||||
9 | ABCD123456790 | NOT AVAILABLE | SEA | ABC CORP | FMM | 15 | 10.5 | 4-Sep | 4-Sep | |||||||||
10 | ABCD123456791 | COMPLETE | SEA | ABC CORP | FMM | 15 | 10.5 | 4-Sep | 4-Sep | 799-12345678 | 4-Sep | 4-Sep | Truck | 12345678-9 | 5 | 5 | ||
Sheet2 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
F5 | F5 | =E5+6 |
G5 | G5 | =E5+11 |