Count cell values based on text colour

Originally Posted by mundo

Hi,

I would like to be able to count the cell values within a range based on the colour of the text.

e.g.

Based on the data below I would like the function to give me a value of 16 (addition of the 2 red values 7 and 9)

1 (Black)
5 (Black)
7 (Red)
9 (Red)
0 (Black)
9 (Black)

This cannot be done with out VBA...
Do you have other conditions for changing the text color?

If you have used conditional formatting to change the colour of the text you can use these the same conditions to count them.

Otherwise as davesexel says, it's VB coding

This was a similar question

http://www.excelforum.com/showthread...t=count+colour