How To Count Colored Cells In Excel
Step 1 – In the Home Tab, click on the Find & Select button
The Find & Select button is located at the right most side.
Step 2 – Click Find
Step 3 – When the Find and Replace text box appears, click on Options.
The options box allows more choices on how to count, especially since counting colored cells are a special type.
Step 4 – Click Format
Step 5 – Choose Format From Cell
Choose Format From Cell
Step 6 – Click on the colored cell that you want to be counted.
As soon as you click on Choose Format From Cell, an eyedropper will appear and you have to click on the color you want to be counted.
Step 7 – Click Find All button
Click Find All button
Step 8 – Under the Find and Replace box, at the bottom most part, the count of the colored cells will appear.
Under the Find and Replace box, at the bottom most part, the count of the colored cells will appear.