In Excel can you count a certain color cell? If I have 4 blue cells can the
program count the color of cells? I if the word "blue" was in the cell it
would count that but that is not what I'm looking for. The cells I'm trying
to count are text cells with no common value.

Thanks,
BKD

Hi B,

See xlDynamic's ColourCounter page at:

http://www.xldynamic.com/source/xld.ColourCounter.html


---
Regards,
Norman



"bkd" wrote in message
...
In Excel can you count a certain color cell? If I have 4 blue cells can
the
program count the color of cells? I if the word "blue" was in the cell it
would count that but that is not what I'm looking for. The cells I'm
trying
to count are text cells with no common value.

Thanks,
BKD

I tried what he suggested with the color index and the excel 2003 I'm running
didn't understand the name "colorindex".

bkd

"Norman Jones" wrote:

Hi B,

See xlDynamic's ColourCounter page at:

http://www.xldynamic.com/source/xld.ColourCounter.html


---
Regards,
Norman



"bkd" wrote in message
...
In Excel can you count a certain color cell? If I have 4 blue cells can
the
program count the color of cells? I if the word "blue" was in the cell it
would count that but that is not what I'm looking for. The cells I'm
trying
to count are text cells with no common value.

Thanks,
BKD

You only read the top of the page I think - you need to add the User
Defined Function (UDF) which is shown right at the END of the page!
bkd wrote:
I tried what he suggested with the color index and the excel 2003 I'm running
didn't understand the name "colorindex".

bkd

"Norman Jones" wrote:

Hi B,

See xlDynamic's ColourCounter page at:

http://www.xldynamic.com/source/xld.ColourCounter.html


---
Regards,
Norman



"bkd" wrote in message
...
In Excel can you count a certain color cell? If I have 4 blue cells can
the
program count the color of cells? I if the word "blue" was in the cell it
would count that but that is not what I'm looking for. The cells I'm
trying
to count are text cells with no common value.

Thanks,
BKD

Hi B,

Paste the problematic code.


---
Regards,
Norman



"bkd" wrote in message
...
I tried what he suggested with the color index and the excel 2003 I'm
running
didn't understand the name "colorindex".

bkd

"Norman Jones" wrote:

Hi B,

See xlDynamic's ColourCounter page at:

http://www.xldynamic.com/source/xld.ColourCounter.html


---
Regards,
Norman



"bkd" wrote in message
...
In Excel can you count a certain color cell? If I have 4 blue cells can
the
program count the color of cells? I if the word "blue" was in the cell
it
would count that but that is not what I'm looking for. The cells I'm
trying
to count are text cells with no common value.

Thanks,
BKD

That means you didn't copy the VBA code into your workbook. It is later in
the artic le.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"bkd" wrote in message
...
I tried what he suggested with the color index and the excel 2003 I'm
running
didn't understand the name "colorindex".

bkd

"Norman Jones" wrote:

Hi B,

See xlDynamic's ColourCounter page at:

http://www.xldynamic.com/source/xld.ColourCounter.html


---
Regards,
Norman



"bkd" wrote in message
...
In Excel can you count a certain color cell? If I have 4 blue cells
can
the
program count the color of cells? I if the word "blue" was in the cell
it
would count that but that is not what I'm looking for. The cells I'm
trying
to count are text cells with no common value.

Thanks,
BKD

Just to add to this, can a formula count depending on cell colour?

( I have always wondered this, just never asked!)

Duncan

http://www.xldynamic.com/source/xld.ColourCounter.html


---
Regards,
Norman

the short answer is no then, it can only be done with VBA.

Many thanks

Duncan