+ Reply to Thread
Results 1 to 2 of 2

Code to count colored cells doesn't work with cells colored by conditional formatting

  1. #1
    Forum Contributor
    Join Date
    05-03-2013
    Location
    Costa Rica
    MS-Off Ver
    MS Excel 365
    Posts
    119

    Code to count colored cells doesn't work with cells colored by conditional formatting

    hi there!

    i have this code to count the number of cells within a certain range that has the same color as another cell:

    Please Login or Register  to view this content.
    However, it doesn't work if the cells are colored using conditional formatting, which is my case.
    How then to overcome this inconvenience?

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,077

    Re: Code to count colored cells doesn't work with cells colored by conditional formatting

    Hello alchavar,

    Why don't you just count the "qualifiers" you have applied to Conditional Formatting? i.e. =COUNTIF(D:D,"X")

    and/or =COUNTIF(E:E,"Y") and/or =COUNTIF(D:D,"Z") etc.

    Regards
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

+ 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. Count Cells colored by conditional formatting
    By sam99 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-19-2013, 02:58 PM
  2. 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
  3. conditional formatting and colored cells
    By henro8 in forum Excel General
    Replies: 9
    Last Post: 07-10-2008, 03:12 PM
  4. Don't Count Cells Colored Red
    By scotfitz in forum Excel General
    Replies: 1
    Last Post: 04-20-2008, 04:19 PM
  5. 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

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