+ Reply to Thread
Results 1 to 4 of 4

Count Color Filled Cells

  1. 08-06-2015, 09:18 AM #1
    cmoore24 is offline
    Registered User
    Join Date
    07-08-2015
    Location
    Richmond, Virginia
    MS-Off Ver
    Office 13
    Posts
    37

    Count Color Filled Cells

    Is there a formula to count only color filled cells? I know there are formulas to count specific colored cells, but I have a sheet that has cells with many different colors and cells with no color fill. I just want a formula that counts ALL color filled cells regardless of what color.
    Reply With QuoteRegister To Reply
  2. 08-06-2015, 09:24 AM #2
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Count Color Filled Cells

    Not easily done plus it doesn't work the way you think it should!

    See this...

    http://www.cpearson.com/Excel/colors.aspx
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  3. 08-06-2015, 09:25 AM #3
    cmoore24 is offline
    Registered User
    Join Date
    07-08-2015
    Location
    Richmond, Virginia
    MS-Off Ver
    Office 13
    Posts
    37

    Re: Count Color Filled Cells

    Much appreciated thanks.
    Reply With QuoteRegister To Reply
  4. 08-06-2015, 09:35 AM #4
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Count Color Filled Cells

    You're welcome!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Count filled and empty cells from the first filled cell in a row
    By mdaoust in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-01-2014, 01:23 PM
  2. counting cells filled with an unconditional cell filled with a color.
    By nils33 in forum Excel General
    Replies: 12
    Last Post: 07-10-2012, 05:04 PM
  3. count conditionally color filled text in excel
    By t0by1 in forum Excel General
    Replies: 0
    Last Post: 06-22-2011, 05:26 PM
  4. How many cells filled with color?
    By codyaaron2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-17-2009, 09:44 AM
  5. Only count a cell filled in with color
    By spowell in forum Excel General
    Replies: 2
    Last Post: 02-05-2009, 10:39 PM
  6. How do I sum up values only in cells that are color filled?
    By 1959USA in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-02-2008, 02:31 PM
  7. Delete Color Filled Cells
    By ericgcollyer in forum Excel General
    Replies: 2
    Last Post: 08-24-2007, 02:22 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1