You need Bob's function also Tony
http://www.xldynamic.com/source/xld.ColourCounter.html



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Tony" wrote in message ...
I saw this formula on the message board,

=SUMPRODUCT(--(Colorindex(A1:A50 TRUE)=3))

It is suppose to count the cells that have RED Fonts in them. This is what I
want to try and do. But I get an @name error. It does not like the Command
COLORINDEX.

This Function is not in the Paste Function menu. Where dos it come from.

HELP

Thanks Tony