Showing the Differences

[Doug]

I am sure this must be simple but I can't figure it out. I have a web import
on sheet "Import" and a copied version of the old Import on sheet "Old
Import". I would like to have another sheet that shows the difference if any
between the two with respect to column "Q" in each so that I can monitor any
recent changes between the two. Please tell me what I should do???
--

 

[Doug]

On sheet3!Q1 I have put =Sheet1!Q1 to copy over the referencing column. From
there what formula do I need so to only show a value if there is a change
between Sheet1 & Sheet2 for the unique ID in column Q, and if so then show
the difference. Like if Sheet1 says "10" and Sheet2 says "3" then it will
show the difference in Sheet3 of "7".

 

[teri]

I need to compare two worksheets -- duplicate data entry -- and find only the
cases where the two worksheets don't match. The simple case below would seem
to apply, but I'm not familiar with conditional formatting. Could someone
walk me through this? Where exactly do I enter that formula?

Thanks,
teri