How to count cells by color in Spreadsheet?

November 22, 2021
31 Views 0

Graphic skills

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Sometimes, we will highlight duplicate cells with custom colors to identify data easier. But how can we count them? In this tutorial, you will learn how to highlight duplicate cells by color.

1. Open your table in WPS Spreadsheet.

2. Click the Home tab, then select the Find and Replace button or use the shortcut key Ctrl+F.  

How to count cells by color in Spreadsheets.gif

3. In the pop-up dialog, click the Format button and select Fill Color to choose format from cells. For example, we want to count the number of green cells, click any green cell in the table. Then, click Find All.

4. You can see the counting statistics in the lower right corner of the resulting page.


How to count cells by color in Spreadsheets2.gif