How to compare columns to seek for new and/or removed items

Hello all!
I know this is my first post here, but it seems a great community, and I've been seeking for long and I haven't been able to find the answer to this by myself.

I'm sort of a newbie in Excel, I've been using it for years, but I never used complex stuff, only the direct and simple ones.

At the moment I do need a tool to compare codes. The thing is, I have a database with thousands of codes, which may or may not repeat themselfs. This database is refreshed daily and I need to know what's new and what's out of it.

The other info in the database I don't really need, I just need to check if there are new codes or old ones are out. The answer could be in red and green, or something like that.

I've attached a sample of what the database look like.
If anyone could give me an hand I would be most gratefull!!

Thank you in advance,
Miguel Pereira