Ahh ok, thanks, will give it ago

"Gary''s Student" wrote:

Before the formulae in the webpage will work you need to enter the VBA code
near the bottom of the webpage.
--
Gary''s Student


"Missile" wrote:

Thanks for the reply, unfortunatly when I try one of the solutions all I get
is an error. i don't know why but I am unable to get it to work. Even when I
tried to find the colorindex, that would not work.

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Missile" wrote in message
...
I want to be able to count the number of cells that have coloured text
from a
range of cells. Is their a way to do this, I tried "countif" but was
unable
to get it working.

Thanks