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!
--------------------
(Ms-Exl-Learner)
--------------------
"lputnam" wrote:
> 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.
|
Similar Threads
