+ Reply to Thread
Results 1 to 5 of 5

Counting colored cells -OR- changing cells colored by conditional formats to "real" colors

  1. #1
    Forum Contributor
    Join Date
    01-09-2009
    Location
    NJ/NY
    MS-Off Ver
    Excel 2007 & 2016
    Posts
    124

    Counting colored cells -OR- changing cells colored by conditional formats to "real" colors

    I have sheets with certain cells colored by conditional formats. I'd like to count the number of cells in each column that are colored, but a VBA module I tried doesn't recognize cells colored by conditional formats. The module does work, but I'll stress that I know nothing about VBA; there were good instructions with this, which probably is the only reason I was successful in running it. So, I guess this could be a two-part question; is there a way to count the number of cells colored by conditional formats? If not, is there a way to convert these cells into "real" colors that can be counted?

    Thank you.
    Last edited by OverKnight; 01-20-2016 at 01:56 PM.

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Counting colored cells -OR- changing cells colored by conditional formats to "real" co

    Usually if you are using a formula to conditionally format the cells you can use a countif with the same formula.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Contributor
    Join Date
    01-09-2009
    Location
    NJ/NY
    MS-Off Ver
    Excel 2007 & 2016
    Posts
    124

    Re: Counting colored cells -OR- changing cells colored by conditional formats to "real" co

    Thank you, Sambo Kid. Very sorry about the delayed reply. I played around with countif, but I wasn't able to make it work. I've attached a sheet with an example of the data I am working with. Could I ask you (or anyone else) to show me how this can be done?
    Attached Files Attached Files

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Counting colored cells -OR- changing cells colored by conditional formats to "real" co

    offhand this is the best I can do, I had to use helper columns and based it on your conditional formatting rules for the countif statements.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    01-09-2009
    Location
    NJ/NY
    MS-Off Ver
    Excel 2007 & 2016
    Posts
    124

    Re: Counting colored cells -OR- changing cells colored by conditional formats to "real" co

    Thanks very much. For what I'm doing with these sheets, helper columns are not a problem at all, especially since they accomplish what I need.

+ 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: 1
    Last Post: 11-09-2013, 02:43 AM
  2. [SOLVED] Counting Cells Colored by a Conditional Format
    By Mike001 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-25-2013, 06:06 AM
  3. Counting Colored Cells
    By thakuromar in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 09-25-2012, 09:16 AM
  4. How to count colored cells with conditional formats
    By lowrey72 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2009, 02:51 AM
  5. Counting cells that are colored in
    By headbanger51 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-06-2008, 03:46 PM
  6. Have blocks of blue colored cells ... want them surrounded by lavender-colored cells
    By rocket1406 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-01-2007, 03:59 PM
  7. "Sum only the colored cells" custom function
    By dtencza in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-19-2005, 01:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1