Using color in Microsoft Excel can be a terrific way to make data stand out. So if a time comes when you want to count the number of cells you’ve colored, you have a couple of ways to do it. Maybe you have cells colored for sales amounts, product numbers, zip codes, or something similar. Whether you’ve manually used color to highlight cells or their text or you’ve set up a conditional formatting rule to do so, the following two ways to count those cells work great. Count Colored Cells Using Find This first method for counting colored cells is the quickest of the two. It doesn’t involve inserting a function or formula, so the count will simply be displayed for you to see and record manually if you wish. Select the cells you want to work with and head to the Home tab. In the Editing section of the ribbon, click “Find & Select” and choose “Find.” When the Find and Replace window opens, click “Options.” Known formatting: If you know the precise formatting you used for the colored cells, for example, a specific green fill, click “Format.” Then use the Font, Border, and Fill tabs in the Find Format window to select the… Click below to read the full story from How To Geek
Read More