How to compare two excel tables to find different data?

I often encounter two Excel tables with similar data at work. Maybe the first one is the original data, and the second one has some modifications. How can I see the modifications by comparing the two tables? What data was collected?

1. Select the data in Table 1, click [Conditional Formatting] - [New Rule]

2. Select [Format cells containing only the following content], and set the following options to [Not equal to], the area selected here is =Sheet2!A1, and then click [Format], for example, select red, and confirm. At this time, the different data in the two tables will be marked in red in Table 1 (as demonstrated below)

This article comes from the Excel basic tutorial column: http://www.php.cn/topic/excel/

The above is the detailed content of How to compare two excel tables to find different data?. For more information, please follow other related articles on the PHP Chinese website!