I got a new task assigned at my work I can't solve by myself because this is not my expertise.
What goal do I want to reach?
I want a macro/condition to fill in a specific column based on a few value's.
Simplified Example:
If you look at SKU "123B" you see Action "Delete" with a quantity of "2" and below you see Action "Add" with a quantity of "1". This means the "Add" quantity is lower then the "Delete" so the "Add" field needs to be colored red
[ATTACH=JSON]{"alt":"Click image for larger version Name:\tE6a3W.png Views:\t1 Size:\t6.4 KB ID:\t1197393","data-align":"none","data-attachmentid":"1197393","data-size":"full","title":"E6a3W.png"}[/ATTACH]
Result : This is how it should look after the macro/condition is ran.
[ATTACH=JSON]{"alt":"Click image for larger version Name:\tlJ6iF.png Views:\t1 Size:\t6.7 KB ID:\t1197394","data-align":"none","data-attachmentid":"1197394","data-size":"full","title":"lJ6iF.png"}[/ATTACH]
A part of a real example looks like this:You can see many of the same "SKU's" but not all part numbers are the same
https://imgur.com/a/wmKmE
So what the macro/condition has to do is match SKU with Part NR then check difference between the delete/add quantity and if the add quantity is lower then the delete Add needs to be filled in red.