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
https://i.stack.imgur.com/E6a3W.png
Result : This is how it should look after the macro/condition is ran.
https://i.stack.imgur.com/lJ6iF.png
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.
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
https://i.stack.imgur.com/E6a3W.png
Result : This is how it should look after the macro/condition is ran.
https://i.stack.imgur.com/lJ6iF.png
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.