counting coloured cells

[Tony]

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

 

[Ron de Bruin]

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

 

[CLR]

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

 

[Adam]

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: