How to get Total of Colored Cell in Selected Range
 

DearAll
in Selected Cell Range I have some colored cell (not all selected raged full
of colored cells). I use different colors in selected range. Now I want to
count how many colored cell in selected range? and what is the total of
different colors which I use.

How to get Total of Colored Cell in Selected Range
 

Try the following link

http://www.xldynamic.com/source/xld.ColourCounter.html

HTH

"Qazi Ahmad" wrote:

DearAll
in Selected Cell Range I have some colored cell (not all selected raged full
of colored cells). I use different colors in selected range. Now I want to
count how many colored cell in selected range? and what is the total of
different colors which I use.