Compare the two-sheet data using formulas & conditional Formatting

[Patel raj]

Hi all,

I want to compare the two-sheet data using formulas & conditional Formatting,
Attached is reference file.
The Old sheet have data which were used previously & after some updates new data has been generated.
I want to compare both the sheets Data & Highlight the data Mismatches between Both the sheet.
Comparison will be based on Column A (Unique Number)
Common mismatch found are
Unique value has different rows
Column B, c, d, e, f, g data may change
There is no problem is the comparison is done on the same sheet by coping data of other sheet.
The output should Highlight the differences with suitable colors.
Thanks,
Patel

[Bo_Ry]

Please try this on Sheet New,

Select A3:H24 Press Alt H L N > Use a formula > =ISERROR(MATCH($A3&$B3,Old!$A$1:$A$21&Old!$B$1:$B$21,)) > Format > change fill color > Ok

[Patel raj]

Hi Bo_Ry ,

I have tried to do it but not able to get with it. Can you please add formula in n attached excel sheet?

[Bo_Ry]

Please see attached

[kvsrinivasamurthy]

Comparing in same sheet.
For CF for A3

Please Login or Register  to view this content.

Select A3:H25 then apply formla for CF.
Formatted for -->fill --> Red