+ Reply to Thread
Results 1 to 3 of 3

expanding colorfunction to count more than one colors in a range

  1. #1
    Registered User
    Join Date
    02-08-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    10

    expanding colorfunction to count more than one colors in a range

    Hi there,

    How do I alter the colourfunction module to allow me to count the values for more than one color in a range?

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: expanding colorfunction to count more than one colors in a range

    why not just use it multiple times?
    also it appears to be a version of this from ozgrid this one works the one you posted doesnt
    Please Login or Register  to view this content.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    02-08-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: expanding colorfunction to count more than one colors in a range

    Hi Martin,

    It's gonna more tedious if I need to count more than 5 colors in the same range instead... why not modify it to look for 5 colors?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. For each cell in range loop does not recognize expanding range
    By jhren in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-07-2013, 07:49 AM
  2. [SOLVED] Count all colors in a range
    By NotQuiteThere in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-06-2013, 02:33 PM
  3. Replies: 1
    Last Post: 11-19-2012, 12:04 PM
  4. Count w/colorfunction and two criteria
    By Figboot in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-17-2009, 08:17 AM
  5. Count the colors in the dynamic range
    By martinofyre in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-10-2008, 08:04 AM

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