PaigeWarner
New Member
- Joined
- May 27, 2020
- Messages
- 48
- Office Version
- 365
- Platform
- MacOS
I want to set conditional formatting with a formula for column N, when we mark something as Complete, that it highlights the whole row from column A to column N.
Here is an example:
Here is a Copy and Paste version:
Thank you in advance for any assistance you can provide!
Here is an example:
Here is a Copy and Paste version:
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 | 2. Awaiting Vendor Response | |||||||
81920 | PQR Incorporated | Mike Doe | Collin | 12/15/2020 | 12/15/2020 | 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!