Checking for errors

[Daniel]

I need to check that data entered into a document is correct,
I have loaded a spreadsheet from the text file and saved it as a xls file.
Column B and D are supposed to show the same data
but errors have been made, is there some way to have Excel compare column B
with D and indicate rows where B and D do not match?

thanks

Daniel

 

[mar10]

If you put +b1=d1 in cell e1 ( or whatever cell is free )
you'll see TRUE if they are the same, or FALSE if not -

 

[Daniel]

Thank you