count by color in excel 2007

[sblanky]

I've read several places that say that excel 2007 can count by color,
but no where i've seen that follows it up with a sample. And my excel
2007 help is not helping...

I would think it would be something like:

=countif(A1:A10,cellcolor("yellow"))

That's what I'm looking for. Yes, I know there's a VBA solution for
pre-2007 versions of excel, but if someone could point me to the
claimed worksheet function solution, I'd appreciate it.

 

[Harlan Grove]

(e-mail address removed) wrote...

I've read several places that say that excel 2007 can count by color,
but no where i've seen that follows it up with a sample. And my excel
2007 help is not helping...

I would think it would be something like:

=countif(A1:A10,cellcolor("yellow"))

That's what I'm looking for. Yes, I know there's a VBA solution for
pre-2007 versions of excel, but if someone could point me to the
claimed worksheet function solution, I'd appreciate it.

You've been misinformed. There's no way to do this in formulas without
VBA in Excel 2007.