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.