comparing stock take data to system report to find errors

hi Pepe

thank you for your super fest response and im really sorry but I'm new to excel and i know the basic so apologies if I sound stupid, the data I have is in raw format. on previous occasions I would manually check each cell and any items that didn't match I would cut and paste to a new sheet.
I have attached a file on manage attachments and ive highlighted three cells

yellow = means items on stock take sheet but not on system report
orange = means items on system report but not on stock take sheet
red= means items on both sheets -

the orange and yellow dat is what im trying to find so that I can correct any errors

hope this makes sense and thank you

If I understand correctly then the following does what you want:
On the 'Stock take' sheet the conditional formatting formula for yellow is: =AND(A2<>"",SUMPRODUCT(--('system report pull'!$A$1:$A$1735=A2))=0)
the formula for red is: =AND(A2<>"",SUMPRODUCT(--('system report pull'!$A$1:$A$1735=A2))>0)
On the 'System report pull' sheet the conditional formatting formula for orange is: =SUMPRODUCT(--('stock take'!A$2:AI$93=A1))=0
the formula for red is: =SUMPRODUCT(--('stock take'!A$2:AI$93=A1))>0
Let us know if you have any questions.