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.


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




And that's it !

Juan Pablo G.
Change where