How to use the table for range screening

I have seen ways to compare table differences using WPS text. Since the WPS spreadsheet software does not provide a way to directly compare the differences between the two tables, this method is an effective solution. So, is it really impossible to compare the differences between the two tables by the WPS spreadsheet software alone? In fact, by mining the WPS table function, it is also possible to compare the tables using the WPS table itself. We use the comparison of the contents of the two home appliance sales as an example to illustrate the comparison method. Two worksheets are placed in Sheet1 and Sheet2 of the workbook (Figure 1). The specific idea of ​​comparison: using the COUNTIF function, directly judges on two worksheets of a workbook; combined with the conditional format, the different data appearing in the judgment result is marked with the specified font color. The specific comparison steps are as follows: Step 1: Select the data comparison area of ​​the Sheet2 data table, and then click “Formula → Name Manager> (Figure 2), after setting the current data area to a name (such as XSL) Determined to facilitate subsequent take-in calculations (Figure 3). Step 2: Switch to the data sheet Sheet1, select the area corresponding to the data area of ​​the Sheet2 table, and click the menu command “Start → Format → Conditional Format” to select the condition type as “Formula”. Enter the function “=COUNTIF(XSL,A2)<1” (Figure 4) in the conditional format. Click the "format" button to specify the font and color of the cell data display when different data appears under the "Font" tab, and then confirm. Step 3: At this time, the “Conditional Format” window will display the preview of the set cell format. Click the “OK” button to display all the data in the set color in the Sheet1 table. Cell (Figure 5). Tip: The function COUNTIF is used to count the number of times a particular value appears within a certain range. If the formula returns a value of 0, it means that the item does not appear in this range. In this case, the value of the corresponding cell is different. The conditional format automatically determines this situation and is marked in the cell with the set font color. This article comes from [System Home] www.xp85.com Related articles recommended: 1. How to automatically change the time data of the table 2. Use the Excel form password function to manage the document 3. How to use the WPS form to extract the ID date of birth for three seconds