Count by Cell Text Color

I would like to count cells in excel based on the color of the text in the cell. I found the code below. It seems to work well, except in regard to one thing: when I have a cell within the range that is formatted to utilize the specific color being identified, the code will count that cell even if the cell has nothing in it. Is there any way to modify this formula such that the count will only include cells within the range that have data in it (or, more specifically if it matters, a number in it)?

Thanks!!

Code:
------------------------------------------------------------

Please Login or Register  to view this content.

-----------------------------------------------------------

This is the corresponding code I am using for sum, by the way, which seems to work well:

Please Login or Register  to view this content.

Hello excel-help,

You seem to maybe have forgotten the Forum Rules.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Regards.

Post deleted.

Hello excel-help,

You need to add another IF statement to the code...

Please Login or Register  to view this content.