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://m.sbmmt.com/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!