counting coloured cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top