Comparison between 4 columns

**johnmathew** · 08-08-2012, 03:44 AM

Hi,

I want to compare ABCDE columns with HIJKL columns if any mismatches it should reflect in next columns.EXC1.JPG

Please find the screenshot for your reference

**johnmathew** · 08-08-2012, 05:20 AM

Any suggestions on this requirement.This would be a great help for me

**Ace_XL** · 08-08-2012, 05:25 AM

Why not use conditional formatting in the second set?

For instance, in H2 use --cell value --not equal to --A2--format yellow and copy paste formats across your range

**johnmathew** · 08-08-2012, 05:32 AM

Sorry i am new to excel..Can you please post a doc with result or formula so that i can try myself.

**Ace_XL** · 08-08-2012, 05:36 AM

See attached..

**johnmathew** · 08-08-2012, 05:38 AM

Sorry didnt understood your intention. No formula exist in this..Please try with my attached doc.

**johnmathew** · 08-08-2012, 06:23 AM

Hi,

Please find the attachment and i required wrong cell values to copy in the next column. Suggestion please

**johnmathew** · 08-09-2012, 01:37 AM

Hi,

Any suggestion on my requirement pls

**Ace_XL** · 08-09-2012, 01:59 AM

How do you define wrong cells? Will mismatches in the 2nd range be the wrong ones or the 1st range?

My solution in Post#5 uses 'conditional formatting' for the 2nd range (no forumlas in the cells) to highlight discrepancies in the 2nd range.