15,796,984 members
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
Updated 29-Mar-17 14:19pm
Member 13036251 29-Mar-17 15:18pm
Are you trying to compare the columns or the rows? Also, do you have a sample file?

## 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)`

## 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.

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.

## 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.

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.