Operation steps

​ ​ 1. Open the WPS table, insert the data table that has been created, select the column to be searched, press Ctrl+F, then enter the search content, and click Search All.

​ ​ 2. The option for the data value in the selected column to be king is immediately displayed below. Click on the option to correspond to the position in the table.

​​ 3. Next, color-code the same content. Select column A, click Format--Conditional Formatting, set the conditions as shown below, and then add.

​​ 4. You can set the font color to distinguish other data. The final result is as follows.

5. After confirmation, the data in column A will be filtered according to your conditions, and the effect is as shown in the figure below.

The above is what the editor said aboutI hope it will be helpful to everyone. Please pay attention to Huajun Software Park for more exciting tutorials.