Hello,
I need help in creating a VBA macro that would compare a row/template to multiple rows then be highlighted if there are differences.
This is the template:
Template | Loan | Interest Rate | Interest Type | Terms |
Template1 | 1 | 5 | Fixed | 60 |
And the below records should be checked if they are in line with the template above. If not, they should be highlighted:
Attached the file for reference.
Hope you can help!
Loan | Interest Rate | Interest Type | Terms |
1 | 5 | Variable | 30 |
3 | 3 | Fixed | 60 |
1 | 5 | Fixed | 60 |
2 | 4 | Fixed | Variable |