Hello Team,
I am having a requirement where I need to check the summation of all possible combinations of column Quantity is equals SL_Quantity OR NOT.
How do I know the summation of which all rows value of Quantity column is equals SL_Quantity using conditional formatting.
Let say C5+c8+c11+c2=E2.
Then in this case how do I know which all rows of column "Quantity" I have to add to make the value equal to "SL_Quantity" , also I will have to highlight those rows( C5,c8,c11,c2) with green color.
I am having a requirement where I need to check the summation of all possible combinations of column Quantity is equals SL_Quantity OR NOT.
How do I know the summation of which all rows value of Quantity column is equals SL_Quantity using conditional formatting.
Let say C5+c8+c11+c2=E2.
Then in this case how do I know which all rows of column "Quantity" I have to add to make the value equal to "SL_Quantity" , also I will have to highlight those rows( C5,c8,c11,c2) with green color.