Formula to Identify Highlighted Cells

I have spreadsheet where I will be manually highlighting specific cells. I would like to be able to count the cells that are highlighted. Attached is a sample worksheet, where I want to return the count of highlighted cells on the sheet in E2. My actual spreadsheet is much larger which is why I would need a formula or function that can do this for me. I did some research online and it seems most solutions require the use of VBA, which I don't have experience with. Is there another way to do this?

Nothing without VBA. That said, you could AutoFilter the red cells and use

Formula:

Please Login or Register  to view this content.

See: https://www.howtoexcel.org/count-colored-cells/

No, you should put it in a Standard module, not a Sheet module.

Like so?
standard module.png

Then how do I get it to run? I'm really a beginner at this so I would appreciate if you could walk me through it.

Yep, like that. In a cell in a worksheet, use =COLORCOUNT(B2:F20, A1), for example.

The range (B2:F20) is the range you want to count. The cell (A1) is the cell whose colour you want to count.

I can't test it as I’m using an iPad but, yes, that looks perfect.


If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.