Need help to count by font color -
I have added a module from this site to 'count by font color' which works well at home with my Excel 2010 version, but when I try to use it at work (Excel 2003) it malfunctions in 2 ways.
First, the formula 'GetFontColorIndex' for automatic (black) returns -4105, which I am not sure about as I thought it should be 1, but the non-automatic (black) returns the number 1so I am at a loss....
Second, with the command 'CountFontColor' I end up counting all cells in the range, including the cells that are blank, which I do not want.... Any help would be much appreciated!
Bookmarks