MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Counting cells that have a specific format


Posted by Dave on January 23, 2002 8:10 AM

Is there a way to count cells that have a specific format? Such as count only the cells with red text in this range.


Posted by Juan Pablo G. on January 23, 2002 9:10 AM

Use this UDF i did.

14070.html

This works with cell backgrounds, but can be modified to count font colors. Just change where you find (3 times to be exact)

.Interior

with

.Font

And that's it !

Juan Pablo G.
Change where