Comparing cells in two excel sheets to see if those cells match and if they do not change their font color

[ebreaks]

Hi,

I am comparing two long excel sheets that are nearly the same, the only difference is that sometimes some of the cells from one excel sheet gets updated and it is difficult to notice that change in that cell.

So, basically I want to check cell values and see if they match, and if not I want excel to mark those cells with red font for me so I can quickly spot the discrepancies. Is there a way to write this as a macro, it seems simple, but I am not that familiar with VBA yet.

thanks!!

 

[mumps]

In what column in each sheet are the cells you want to compare?