Compair list macro

Hello and thank you for your help.

I have a macro that compares 2 lists and highlights the unique values in column A after comparing them to column B. This macro only being some what basic has a flaw.

It works perfectly until a unique value is added into column B at that point it stops working where it highlights the whole of column A red underneath the unique number in column B which is not what I need to happen.

So my hope is that some one can help me solve this issue and help me make it also highlight unique values in column B in a different colour as this macro is used to check hundreds of values at a time and some are duplicates. I used to just use the remove duplicates tool but because of the fact that in my lists that there could be more than one of the same numbers this did not work often leading to mistakes.

This is the macro I use

Please Login or Register  to view this content.

Once again thank you for your help

Hello and thank you for your help unfortunately it does not work as I need it to
Untitled.pngThis is knid of what I am working with but in a larger scale and you can see in column A I have a list of what I am expected to have and on the left it is what I actually have. As you can see by the picture that I only have one 7894561 but it has cleared both of them in column A which cant happen and as a but apart from that the macro works fine.

As a sub not it is possible for cells to only turn green when it is a unique number not auto filled?

Thank you for you help.

Hello and thank you hopefully this should be what you are looking for
Example.xlsm

That is what I would like to happen.

But if I change any of the numbers in column B the macro does not work.

Example 1.xlsm

as attached you can see that the bottom values when removed do not highlight the bottom ones as missing even though they are.

Thank you for your help

sorry for the confusion

the logic behind the macro that I need would be

Start at cell B1 use this value and compare it to the the values in column A (top to bottom or bottom to top does not matter to me but sometimes one list may be shorter than the other this generally varies)

if the value is found in column A then everything is ok and nothing should happen

if a cell value in column B is not found in column A then that value in column in column B should be highlighted

after all cells in column B have been checked if a all the cells in column A with a unique value should be highlighted

as I cant code in VBA very well this is the best explanation I can give

basically I need unique values highlighted in each column. Bearing in mind that there can be 2 or more of one value in each column which makes this more difficult.(I started off using the delete duplicate functions but if I had the value 01 in column B and two of this value in column A i.e. 01 01
then performing the remove duplicates it will remove both of the 01's in column A even though I only have one in column B when really I want it to leave one 01 as I only have one of them and need to find the other 01)

I hope this make some sense and will help.

thank you very much it work well