Hello all,
I have a sheet that has duplicate order numbers that have different quantities (either 1 or -1).
I am trying to build a macro that will look at the order number and add all the quantities for the rows and highlight the cells in column I. If the quantity for that order number is -1, highlight all the cells in column I red where the order number is the same in column G. If the sum of quantities for that order number are 0, highlight it green. If the total quantity sum is 1, leave it unfilled. (-1=Red; 0=Green; 1=Unfilled)
An example is 224805, it appears twice, once with quantity 1 and again with quantity -1 in rows 5 and 6. I want it so that it recognizes the quantity as 0 and highlights I5 and I6 green. 257143 on row 21 only appears once with -1, so it would be highlighted red.
Please see the attached file for an example that uses dummy data.
Bookmarks