Link to home
Start Free TrialLog in
Avatar of ssblue
ssblueFlag for United States of America

asked on

Compare 2 columns And Compare 3 columns (one with others 2)

Compare 2 columns for unique value.  I have columns A  B   and they all contain the same information I think.  I would like to highlight the rows where A and B don't match.

Row     Column A      Column B
 1            3/27/18            3/27/18
 2             7/9/18               0
 3           No Match         Critical
 4           1082455            1082455
In this example rows 2 and 3 would be highlighted or the Cells that don't match would be highlighted
Additionally, if I wanted to compare 3 columns how would I Highlight the odd cell?
Avatar of J0rtIT
J0rtIT
Flag of Venezuela, Bolivarian Republic of image

Hi ssblue, where are you doing this?, I've modified the topics on your questions since this is not related to exchange (Microsoft Exchange server)
On excel right?, I mean do you want a macro? a script ? how do you want to do this?
ASKER CERTIFIED SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ssblue

ASKER

Thanks for making that correction.
Avatar of ssblue

ASKER

Thanks for the help
You're welcome!
There you go, you didn't have any answer because it was in the wrong topics. Have a good day everyone
Thanks Jose and you too! :)
Avatar of ssblue

ASKER

Can you and how would you use conditional formatting to compare 3 columns instead of the VBA?
if I wanted to compare 3 columns how would I Highlight the odd cell?
Do you mean when value in one cell is different from two other cells?
Avatar of ssblue

ASKER

Yes
Say your data is in the range A1:C4 then select the range A1:C4 and make a new rule for conditional formatting using the formula given below...

=COUNTIF($A1:$C1,A1)=1

Open in new window

Avatar of ssblue

ASKER

THANKS
You're welcome again!
For future reference, once your question is answered you can open a new one so you can award the points he got for answering 2 questions :)
That's okay Jose as the second question was also included in the original question. :)
Ohh I see! :P it's just one question for posting :) so everyone with the same problem can be able to query and resolve the problem its problem with the helpful answers haha! :)
You are right. The second question was a good candidate for a standalone question as it was a good question and might help others as well.
Avatar of ssblue

ASKER

Point taken! Thanks everyone!
I've just updated the Title of the question, hopefully someone could find it there :)

Jose!