in F2, type =EXACT(D2,E2) and drag it down.

Or

Select E2 go to Format Conditional Formatting select Cell Value Is
select Equal To type D2 Click on Format Choose color.


"Kevin" wrote in message
...
After combining two worksheets, I have two columns that are supposed to be
identical, but are not.
Starting from row 2, column D has 7209 numeric entries, while column E has
7214.

How can I identify what values do not match up.

Thanks for saving me from scolling. I could do that once but this will be
an ongoing issue. Also, please I am not a programmer but do have a
knowledge
of functions.