Color cells a different color based on same content from a different tab

Hi guys. i need some help with regards to cell formatting. basically i have an excel database which i created for my online store. every week i receive a new pricelist from my suppliers and they indicate via email the new product numbers that have been inserted. sometime it can be over 100 products so manually looking for each product code and copying the relevant information into my database can be time consuming. is it possible for excel to automatically color a cell in tab 1 (main pricelist) column A a certain colour if tab 2 (missing) column A has the exact same value?
ive inserted the excel file and have manually colored A6 a reddish color since that product code exists in Tab B (missing) as an example of what needs to be done. please assist

link below.

http://s000.tinyupload.com/index.php...84203742054356