PaigeWarner
New Member
- Joined
- May 27, 2020
- Messages
- 48
- Office Version
- 365
- Platform
- MacOS
I would like a formula for column F, that I can plug into conditional formatting where the lettering turns bold red when there is no date in column G, after it has passed a two week mark. So if we haven't received a response in two weeks, then it is in our face to follow up.
Here is the text in the table above, copy and pasted:
Thank you in advance for any assistance you can provide!
Here is the text in the table above, copy and pasted:
| Vendor ID | Vendor Name | Merchant(s) | Team Member | First Processed | 1.a. Emailed Vendor | 2. Received Response | 3.a. Merch Approval Requested | 3.b. Merch EDI File Approved | 4.a. SNOW Ticket Created | 4.b. SNOW Ticket Number | 5.a. Fixes Completed | Status | Notes |
| 11121 | GHI Incorporated | Mark Doe | Doris | 2/5/2021 | 2/9/2021 | 2. Awaiting Vendor Response | |||||||
| 12345 | ABC Incorporated | John Doe | Collin | 12/21/2020 | 12/21/2020 | 1/5/2021 | 1/6/2021 | 1/6/2021 | N/A | RITM0128114 | 1/11/2021 | 6. Complete | |
| 67891 | DEF Incorporated | Jane Doe | Doris | 2/3/2021 | 2/10/2021 | 2. Awaiting Vendor Response | |||||||
| 31415 | JKL Incorporated | Jessica Doe | Doris | 12/22/2020 | 12/22/2020 | 2. Awaiting Vendor Response | |||||||
| 16171 | MNO Incorporated | Larry Doe | Doris | 12/22/2020 | 12/22/2020 | 1/13/2021 | 2. Awaiting Vendor Response | ||||||
| 81920 | PQR Incorporated | Mike Doe | Collin | 12/15/2020 | 12/15/2020 | 1/13/2021 | 2. Awaiting Vendor Response | ||||||
| 21222 | STU Incorporated | Janet Doe | Collin | 2/3/2021 | 2/10/2021 | 2. Awaiting Vendor Response |
Thank you in advance for any assistance you can provide!
