Compare two sheets, highlight differences

Hi

i have sheet1 and sheet2 that has a list of products and their information

sheet1 is month 1
sheet2 is month 2

i need to compare the two sheets, then highlight any differences on sheet2

a completely new product needs to be highlighted in yellow
and any differences on the same product to be highlighted in red

i have attached a spreadsheet with my desired result

thanks so much in advance

any help on the above would be much appreicated!
thanks

Hi Sir, i do not require the formula thanks,
just differences highlighting

yellow for a completely new line
red for cell differences on the line that is on both sheets

Hi
i have code to compare the two sheets now

however i have a problem where if the product codes are not in order, it effects every row thereafter

i need to use the product code as the index then compare that row,
if the product is in sheet2, but in sheet1, then i need it highlighting

thanks

Hi Trebor76
your code works great, just the only problem i have if is the product codes are not in the same order on both sheets which is very possible

thanks

perfect thank you