Count number of cells in a cell range that has a particular color

[myletterboxnp]

Hi all,

A2:A20 cells have different colors such as red, green and yellow.

In A22, what should be the formula to count the number of the red cells in the range A2:A20

 

[myletterboxnp]

Thank you so much for your help - it worked! and please pardon my ignorance.

 

[Joe4]

Thank you so much for your help - it worked! and please pardon my ignorance.

No worries!

I am glad we got it sorted out.
There is an awful lot in that initial link, and it can be easy get overwhelmed. But we really only need a small part of it, and we don't even need to know how to write or understand the code, just to copy and paste and use it "as-is".

There are two main things you can create with VBA:
1. Macros (also known as "Procedures") - these are a bunch of steps that can be run either manually or automatically (dependent upon some conditions)
2. User Defined Functions (UDF)- there are our own functions that work the same like any other Excel functions (to be used in formulas)

What we used here was a UDF that someone else created. So we just needed to "plug-and-play"!