Can anyone help with an Excel formula plz??

[rokerij]

Hi guys, I have done an Excel course but it was some time ago & I have forgotten most of it

What I have is 4 columns of data (letters/numbers/letters/mixed) on one spreadsheet and 4 supposedly identical columns on another sheet (can be upto 600 lines)

I need to compare 4 against the other 4 and highlight any cells that are different, I can put all 8 columns on one sheet if that helps.

Thanks in adv for any help, I have tried searching the answer but im gettin bogged down & confused like - do i need a formula for this or macro or vlookup etc???

 

[rokerij]

Thanks guys, I have not tried to use conditional formatting but i'll have a look, highlighting them sounds good.


I have just tried your formulas Namsni on a small file and they are working so thanks for your help

 

[rokerij]

sorry, im having trouble setting up conditional formatting and exactly where And(A1=E1,B1=F1,C1=G1,D1=H1) goes!