Compare two excel sheet and update the status on basis of cell color.
- Compare two excel sheet with column Name “Customer Name” if Customer Name Found
- Also compare Column “D:I” when both data are matching we need to update Status in “Update Status” sheet as per color of “Sample” sheet.
| Color | Status |
|---|---|
| 1: Green: | |
| [Sample.xlsx | attachment](upload://tEwzG3xdNbZoEJnS3tkH1YMLUso.xlsx) (9.3 KB) |
| [Update Status.xlsx | attachment](upload://DtFQP8kmy5U7X205eWI7CoLD0Y.xlsx) (9.7 KB) |
| Task Completed on-time | Completed |
| 2: LightBlue: Task has been completed but not on-time | Delayed Completed |
| 3: Orange: Incoming task in the next 4 weeks (at reporting date) | In-Progress |
| 4: Red: Delayed Task (at reporting date) | Delay |
| 5: White: Future Tasks that are due after 4 weeks (at reporting date) | Yet to Start/NA |
Sample.xlsx (9.3 KB)
Update Status.xlsx (9.8 KB)