Excel Macro Fill a field with color based on values of multiple columns

  • 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

    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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!