+ Reply to Thread
Results 1 to 3 of 3

counting colored cells while using contitional formatting

  1. #1
    Registered User
    Join Date
    05-24-2011
    Location
    Earth
    MS-Off Ver
    Excel 2007
    Posts
    9

    counting colored cells while using contitional formatting

    Hello all,
    I'm using conditional formatting to color some cells in my spreadsheet green. I have several different criteria on different columns that colors the cells (green). Is there some way to count the total number of green cells within a certain range?
    I've tried several of the VBA scripts that count color, and these don't seem to work with conditional formatting coloring the cells... At least, the cells seem as if they aren't colored to these VBA scripts. If I color a cell myself, then the scripts work, but the conditional formatting seems invisible to these scripts.
    So is this possible?

    Thanks!

  2. #2
    Valued Forum Contributor realniceguy5000's Avatar
    Join Date
    03-20-2008
    Location
    PA
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    951

    Re: counting colored cells while using contitional formatting

    Hi,

    Have you had a look here?

    http://www.cpearson.com/excel/colors.aspx
    Thank You, Mike

    Some Helpful Hints:

    1. New members please read & follow the Forum Rules
    2. Use Code Tags...Place[code]Before the first line and[/code] After the last line.
    3. If you are pleased with a solution mark your post SOLVED.
    4. Thank those who have help you by clicking the scales at the top right of the post.

    Here...

  3. #3
    Valued Forum Contributor realniceguy5000's Avatar
    Join Date
    03-20-2008
    Location
    PA
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    951

    Re: counting colored cells while using contitional formatting

    Hi,

    Another option is to use is what makes the cell green?

    In the example script below I have validation set to if cell = a then green

    so my script runs through the col "F" and checks all the cells that have an "a" in them and counts them.

    Just a thought...

    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)

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