How to compare two rows with 20 columns of fields, the entire spreadsheet sheet.

Question

1.00/5 (1 vote)

See more:

Hi - I have spreadsheet which has 3000 rows. I need to compare two rows at a time, and hight the difference.
In the past i used this conditional formatting, IF(B2=B3,1,0) <> 1 , and filled the cell with color. there were smaller number of rows. I need to apply this through out the spreadsheet.

any help is appreciate.

What I have tried:

I tried with manual formula for a smaller number of rows in sheet,

IF(B2=B3,1,0) <> 1

this worked. now i need to apply the same to whole sheet.

Posted 29-Mar-17 9:05am

VK19

Updated 29-Mar-17 13:19pm

Add a Solution

Comments

Member 13036251 29-Mar-17 15:18pm

Are you trying to compare the columns or the rows? Also, do you have a sample file?

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Patrice T · Answer 1 · 2017-03-29T13:19:00

Solution 3

This formula is overly complicated:

VB

IF(B2=B3,1,0) <> 1

In Conditional Formatting, select "Formula is" and type the following formula:
To highlight for equality, use =(B2=B3)
To highlight for inequality, use =(B2<>B3)

Posted 29-Mar-17 13:19pm

Patrice T

VK19 · Answer 2 · 2017-03-29T09:22:00

Solution 1

424	E	1549V00424	154:9  		    V	N	N	N		5311 08/25/1998	09/09/9999	04/01/2011	12/07/2016	NEW
424	E	1549V00424	154:9		0	V	N	N	N	0	5311 08/25/1998	09/09/9999	04/01/2011	12/10/2014	OLD

Those are two rows of data i want to compare. I have about 3000 rows of data, and i would be comparing, 1 with 2, 3 with 4, 5 with 6. As pairs.
And if a difference is seen, highlight it.

Thanks for quick response.

Posted 29-Mar-17 9:22am

VK19

Comments

Patrice T 29-Mar-17 19:10pm

Don't use solutions for this
Use Improve question to update your question.
So that everyone can pay attention to this information.
and delete.

VK19 · Answer 3 · 2017-03-29T09:41:00

Solution 2

424	E		V	N	N	N		5311	08/25/1998	12/07/2016	NEW
424	E	0	V	N	N	N	0	5311	08/25/1998	12/10/2014	OLD

I reduced some more fields so it is easy to read, there are 2 rows of data, but there are about 20 columns to compare.

Posted 29-Mar-17 9:41am

VK19

Comments

Patrice T 29-Mar-17 19:10pm

Don't use solutions for this
Use Improve question to update your question.
So that everyone can pay attention to this information.
and delete.