I have a situation where I am comparing two lists that should be identical. I should note that the lists contain text, not numbers. I know that one is correct, and I am looking for errors in the second list. These can be spelling errors, or that an ingredient in the list is appearing in the wrong order within the list.



I know how to get it to highlight unique values within the two lists, which will show the spelling errors, but I need it to also highlight any ingredients that are out of order.

I know that this is possible to do with conditional formatting, I'm just not sure how.

I have attached a file with lists that contain the differences I want to highlight. Idealy, Cells A2, B2, A7, B7, A8, and B8 would be highlighted.

Attached Files

fakeingredientlist.xlsx (8.8 KB, 12 views)