Posted by DaveMcD | | Posted On Thursday, May 20, 2010 at 1:15 PM
I don't know about you, but I use Excel for many different purposes - including tracking projects.
In applications like this I use colors and I use them allot.
Often I find myself in a situation where I would really like to be able to count the number of cells in a range that are a specific color. There isn't any built in functions in Excel to do this. Recently, I stumbled across a nice library of functions that allow you to do many things with color in a spreadsheet.
The following link discusses these functions and supplies a downloadable module of functions that are very useful: