Many newbies are not familiar with the simple operation of filtering by color when using WPS. The editor below will explain the steps of filtering by color. I hope it will be helpful to you.

Open wps and select the data that needs to be marked with color. For example, mark the scores at 60, 50, and 85 in the score column.

Then select the tool to fill the cell color, here it is filled with light blue. These two steps are the prerequisite operations for the final color filtering.

At this time, you need to select the entire table range, find the automatic filter on the toolbar, and select automatic filter in the drop-down menu. Note that you need to select all tables to determine the filter range.

Then select the color filter in the down arrow in the grade column and then select the light blue marked previously.

Finally, we found that all the marked light blue data was displayed, while other unmarked data was hidden. If you want to cancel, you can select Show All in the content filter to restore all the data in the table.

Dear friends, after reading the wonderful content above, you all know the simple steps of filtering by color in WPS!