UDF - to count no. of cells based on user selected colors
In this video you will be able to count the number of cells on the basis of color. This is done with the help of a User Defined Function (UDF). You can also use filter by color but it is not as effective as UDF and also it is not dynamic.