Having trouble with formula to count cells based on font color

[ec99ss]

Hi all
I'm working on a data excel sheet and looking to count the cells in a column that have a certain font color. I wrote a VB function to do this. In the blank cell I wrote the formula to call up the function and count the cells in red (=CountColour(F4:F25,F16) Everything seems to work except it counts all the cells with a number.

Here is where I've narrowed the problem. In column F4:F25 I have another formula that converts certain cells to a red font (based on data elsewhere). What I'm seeing is that my CountColour formula does'nt see that 'red' font and thinks it's black. It's counting all the cells with a number in it.

Any ideas on how I can fix my formula(s)?

Thanks much!

 

[Oaktree]

You may have reinvented the wheel a bit :/

Chip Pearson has an excellent write-up on counting by color here: http://www.cpearson.com/excel/colors.htm

That write-up would have likely created the same end result you're getting now. BUT, he also provides a link to his other write-up on counting by *conditionally formatted color* here: http://www.cpearson.com/excel/CFColors.htm

As you'd imagine, it's more complicated, but it's still doable.

 

[ec99ss]

You may have reinvented the wheel a bit :/

Chip Pearson has an excellent write-up on counting by color here: http://www.cpearson.com/excel/colors.htm

That write-up would have likely created the same end result you're getting now. BUT, he also provides a link to his other write-up on counting by *conditionally formatted color* here: http://www.cpearson.com/excel/CFColors.htm

As you'd imagine, it's more complicated, but it's still doable.

Ahh thank you! Wow this is certainly more complicated. The tinkerer in me wants to play with it to see how to make it work. The "I'm tired and want to get done" in me just wants to say forget it! Haha.

Thanks for pointing me in this direction.