Results 1 to 6 of 6

Count by color font help

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-15-2011
    Location
    Whitby, Canada
    MS-Off Ver
    Excel 2010
    Posts
    121

    Count by color font help

    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!
    Last edited by Greed; 07-18-2011 at 10:20 AM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1