+ Reply to Thread
Results 1 to 2 of 2

Count Colors in Range

  1. #1
    Registered User
    Join Date
    07-03-2014
    Location
    East Lansing
    MS-Off Ver
    2010
    Posts
    20

    Count Colors in Range

    Scenario: AA1:AD1 are the same color, once you get to AE1 it is a different color

    Code right now: Counts how many cells in range are the same color as AA1, then counts how many cells in range are the same color as AB1 (same answer), AC1(same answer), AD1(same answer), AE1 and so on. Since the first few cells are the same color, my function is giving the same answer over and over.

    What I'd like it to do: Give the total number of cells in range with one color, then the next color, etc instead of retrieving the same total over and over for similar colored cells

    Please Login or Register  to view this content.
    Last edited by TheSpriceEffect; 07-16-2014 at 03:04 PM.

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Count Colors in Range

    Hi,

    The following macros implemented in the attached file may point you in the right direction.

    Lewis

    Please Login or Register  to view this content.

+ 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. expanding colorfunction to count more than one colors in a range
    By dilemmax in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2013, 10:50 PM
  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 CF colors
    By kdeppe in forum Excel General
    Replies: 5
    Last Post: 09-12-2011, 02:28 PM
  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

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