+ Reply to Thread
Results 1 to 2 of 2

count values based on cell colour

  1. #1
    Registered User
    Join Date
    01-18-2014
    Location
    bangalore, india
    MS-Off Ver
    Excel 2010
    Posts
    14

    count values based on cell colour

    I have an excel legacy data.
    Data has been marked with different colours (each cells).

    how to count sum of all values with some particular cell (eg. all values marked with yellow color).

    thanks in advance

  2. #2
    Forum Contributor
    Join Date
    09-26-2014
    Location
    Moscow, Russia
    MS-Off Ver
    MSE 10, MSE 13
    Posts
    179

    Re: count values based on cell colour

    Good time of day!

    How about a User Defined Function? Please, check the attachment. Macroses must be allowed.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Best wishes and have a nice day!

+ 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. Replies: 8
    Last Post: 06-29-2014, 10:01 AM
  2. Bar graphs that change colour based on cell values
    By anurajay in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-17-2013, 06:45 AM
  3. Replies: 3
    Last Post: 11-09-2011, 12:05 PM
  4. Sum values based on cell colour
    By 2709236 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-18-2008, 02:37 PM
  5. Count cell values based on text colour
    By mundo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-22-2008, 09:25 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