compare number and material of two product and colorate red differences

[bogd1n]

hello friends

i have a problem i want compare coulomn d and b with j and h and if is different colorate with red

how do that?

[alansidman]

try this:

Please Login or Register  to view this content.

[bogd1n]

try this:

Please Login or Register  to view this content.

result is not i want
number of component is not same
more simple for understand is
i have two materials A and B with number of pcs in product
CASE 1 MATERIAL A IS 2 PCS AND MATERIAL A IS 3 RESULT THEN COLORATE 2 PCS BECAUSE IS DIFERENT(NUMBER OF PCS IS DIFFERENT) AND COLORAE RED
CASE 2 MATERIAL A NOT EXIST IN COULUMN AND COLORATE RED

THIS I WANT

[bogd1n]

result is not i want
number of component is not same
more simple for understand is
i have two materials A and B with number of pcs in product
CASE 1 MATERIAL A IS 2 PCS AND MATERIAL A IS 3 RESULT THEN COLORATE 2 PCS BECAUSE IS DIFERENT(NUMBER OF PCS IS DIFFERENT) AND COLORAE RED
CASE 2 MATERIAL A NOT EXIST IN COULUMN AND COLORATE RED

THIS I WANT

and excel simplified

[alansidman]

I do not have a solution for you. Hopefully, someone else will see a means to provide what you are looking for.