counting coloured cells
 

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

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

If the cells are colored as a result of Conditional Formatting, then you
could use the same conditions to code a helper column and then sort on
it..............


Vaya con Dios,
Chuck, CABGx3


"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

See Chip Pearsons home page for all the VBA codes for counting cells based on
their fill or font

http://www.cpearson.com/excel/colors.htm

/Adam

"CLR" skrev:

If the cells are colored as a result of Conditional Formatting, then you
could use the same conditions to code a helper column and then sort on
it..............


Vaya con Dios,
Chuck, CABGx3


"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