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