Hello!
Here is another challenge for you!
This one follows the previous one: ✓ RPA Challenge 26 - Structured Data Validation
So once you are ready with Challenge 26, you are ready to move on to this Challenge number 27!
Goal of robot
The goal is the same: Let robot mark in red highlight all errors in the input file.
Include those from Challenge 26 + add these checks on top:
| — | column | check |
|---|---|---|
| 5 | ErrorCode | Must match one of the Error codes in Sheet ErrorCodes |
| 6 | ErrorName | Must match one of the Errror Names in Sheet ErrorCodes |
| 7 | Registered | Must contain YES or NO |
| 8 | If column Registered is YES, then column RegisteredBy must be filled in and vice versa (If column Registered is NO, then column RegisteredBy must be filled in) | |
| 9 | If Result = APPROVED, only column ApprovedBy must be filled in, RejectedBy must be empty (and vice versa, for REJECTED) |
Here is the input file: InputData.xlsx (14.0 KB)
How to participate 
- Send me your code in PM
- Post in Reply: Excel sheet with results (highlighted errors)
First three correct, original solvers earn 3 robopoints, next get 1 robopoint.
There is a leaderboard with your score. Those on top positions will be badged by a special challenger badge 
The challenge deadline is 26.9. by the end of the day. You can still submit your projects after the deadline but you cannot earn robopoints. 
A new challenge is published every week or 2 weeks so don’t worry if you did not catch this one. Keep in mind, your submitted files may be published after the deadline so others can learn from solutions.
