Sub CountTextColors()

[cgault]

I found this macro once but cannot find it again. Luckily I copied it t
Excel & modified it to my needs. I wanted to thank the author fo
creating such useful code to count cells by fill or background color
Anyone know who wrote it? I believe the name of the macro is unique

 

[opeel]

This is a commonly asked question. The Vba property which gives a cell
colour is MyCell.Interior.Colorindex. their is an indepth explinatio
on Chip Pearson's site 'here
(http://www.cpearson.com/excel/SortByColor.htm

 

[opeel]

Sorry, misread your question. I don't kow who wrote the exact macro you
talking about

 

[Chip Pearson]

It probably came from my www.cpearson.com/excel/colors.htm web
page.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com