=COUNTIF(range, select items highlighted with specific color)
 

I am trying to create a formula which allows me to create a =COUNIF() count
for items on a given column which are highlighted with a particular color
i.e. yellow, blue or red etc.

Please advise.

Thanks,
AA

=COUNTIF(range, select items highlighted with specific color)
 

See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution

--
__________________________________
HTH

Bob

"AA" wrote in message
...
I am trying to create a formula which allows me to create a =COUNIF() count
for items on a given column which are highlighted with a particular color
i.e. yellow, blue or red etc.

Please advise.

Thanks,
AA

=COUNTIF(range, select items highlighted with specific color)
 

Thank you. This will work. AA

"Bob Phillips" wrote:

See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution

--
__________________________________
HTH

Bob

"AA" wrote in message
...
I am trying to create a formula which allows me to create a =COUNIF() count
for items on a given column which are highlighted with a particular color
i.e. yellow, blue or red etc.

Please advise.

Thanks,
AA