Please some one help me on compare two work sheel cell by cell

Please some one help me on compare two work sheet cell by cell

One way is to use a third sheet, put this in A1
=IF(EXACT(Sheet1!A1,Sheet2!A1),"y","n")
then copy A1 and paste it into the rest of the new sheet, as far as needed.

Since EXACT is case-sensitive, "this" is considered different from "This".

Don't be tempted into using the comparison Sheet1!A1=Sheet2!A1 because it considers 0 and FALSE and an empty cell to be all the same.

A different way is to use conditional formatting to color the cells of Sheet1 that are different from their Sheet2 conterparts. This way, there's no need for a third sheet. Look in Excel's built-in Help to read about conditional formatting.