Count Font Colour

[Guest]

I want a formula that will count the cell if a certain font colour exists. I
have 3 fonts - black, red and green font - and only want to count if black
or green exist.

Helpless.

 

[Niek Otten]

Not Helpless at all:

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|I want a formula that will count the cell if a certain font colour exists. I
| have 3 fonts - black, red and green font - and only want to count if black
| or green exist.
|
| Helpless.