如何将两行与20列字段进行比较，即整个电子表格表。 [英] How to compare two rows with 20 columns of fields, the entire spreadsheet sheet.

问题描述

嗨 - 我的电子表格有3000行。我需要一次比较两行，并且差异很大。

过去我使用了这种条件格式，IF（B2 = B3,1,0）<> 1，并用细胞填充细胞。行数较少。我需要在电子表格中应用这个。



任何帮助都是值得欣赏的。



我尝试了什么：



我尝试使用手动公式表单中的行数较少，

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.

推荐答案

这个公式过于复杂：

This formula is overly complicated:

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

在条件格式中，选择公式并输入以下内容公式：

要突出显示相等性，请使用 =（B2 = B3）

要突出显示不等式，请使用 =（B2<> B3）

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)

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

这是我要比较的两行数据。我有大约3000行数据，我将比较，1与2,3，4,5与6。作为对。

如果看到差异，请突出显示它。



感谢您的快速回复。

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.

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

我减少了一些字段，因此它易于阅读，有2行数据，但有大约20列要比较。

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.

这篇关于如何将两行与20列字段进行比较，即整个电子表格表。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！