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)
.Interior
with
.Font
And that's it !
Juan Pablo G.
Change where
