Hello Team,
I am having a scenario where I need to find duplicate rows based on three columns let's say in my case it would be Col A,Col B and SL QTY
Once I found duplicate rows my next action would be the sum of values of "QTY" column let's say in my case if it would C2+C3 since row 2 and row 3 are duplicates, next I have to compare the value of C2+C3 = E2.
If C2+C3 equals E2-->highlight the duplicate rows with green color
If C2+C3 > E2-->highlight the duplicate rows with yellow color
If C2+C3 <E2-->highlight the duplicate rows with orange color.
Kindly help me out on how to put this logic in conditional formatting dynamically since I will be having huge records in excel.
Thanks,
Prativa
I am having a scenario where I need to find duplicate rows based on three columns let's say in my case it would be Col A,Col B and SL QTY
Once I found duplicate rows my next action would be the sum of values of "QTY" column let's say in my case if it would C2+C3 since row 2 and row 3 are duplicates, next I have to compare the value of C2+C3 = E2.
If C2+C3 equals E2-->highlight the duplicate rows with green color
If C2+C3 > E2-->highlight the duplicate rows with yellow color
If C2+C3 <E2-->highlight the duplicate rows with orange color.
Kindly help me out on how to put this logic in conditional formatting dynamically since I will be having huge records in excel.
Thanks,
Prativa