comparing two columns

L

lputnam

I need to compare cells 2 columns and return a value if different.
e.g.
A1: 2002 B:2002
A2: 2002 B:2003
A3: 2002 B:2002

Need to identify row 2 is different (with an x and a color?) I have about
1000 rows to compare.
I tried some of the formulas listed in this section e.g.
=if(countif(a:a,a25)>1,a25,"")
but didn't return what i wanted.
 
M

Ms-Exl-Learner

Paste this formula in C1 cell
=IF(A1=B1,"Both Are Same","Mismatch")
Now copy the C1 cell and paste it to the remaining cells of C Column depends
upon your A & B Column Data.

For Applying the Conditional Formatting
Place the Cursor in A1 cell and hit Cntrl+Spacebar now the Total A Column
will be selected and extend your selection to B Column by holding Shift +
Right Arrow and you can notice that the A1 will have the White Background
after selection also.

Now goto Format>>Conditional Formatting>>Formula Is>> Paste the below formula
=$A1<>$B1
Click Format and set the desired Font colour and background as per your
desired give Ok and Hit Ok once Again. That’s It!

Remember to Click Yes, if this post helps!
 
D

David Biddulph

Conditional Formatting/ Formula is: =A1<>B1
Set your desired format

Or (to format cell B1), Conditional Formatting/ Cell value is/ Not equal to:
=A1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top