ip extract from two rows

First, I'm apologizing for my bad english and I'm going to try to describe it to you the best i can. I have 738 IP values which i need to compare to other 756 IP values to find the same ones and the missing ones. So i have first ip's in A row and second ip's in B row. Problem is that B row includes some other values and at the end of the sentence there is IP so it's kinda messy. I would like that the same ip would color green and the missing ones red but that's just how i see it. I attached the file. I would be grateful if someone could help because I'm new at the job and this is what i got but surely i don't want to do it by hand

If you're not adverse to a bit of VBA, here's a UDF that will extract the IP addresses into another cell:

Please Login or Register  to view this content.

Should then be fairly straightforward to compare with VLookup