Hi

I have a really hard one and hope I can explain it.
I am using XL 2002 SP3

I have two sets of two columns. In each case,
in column A is a list of code, column B shows the product name,
the second set of columns have the same type of list, but not exactly the
same content.
Some of the products in column B of the second pair of Columns have the
wrong product name.

Is it possible to do a query where if the codes in columns A are the same
but the adjacent name in column B is not, it is highlighted in some way.

I can put the second two columns into the same spreadsheet making them A, B,
C and D.
Please note that the codes will not be aligned as the lists are not complete
duplicates.

I hope you understand this and someone can help.

thanks