+ Reply to Thread
Results 1 to 12 of 12

Count color coded cells ( formatted conditionally ) in Excel 2010

  1. #1
    Registered User
    Join Date
    02-01-2021
    Location
    Brussels
    MS-Off Ver
    2010
    Posts
    6

    Count color coded cells ( formatted conditionally ) in Excel 2010

    Hello,
    I am Excel beginner and have a deadline for this reporting which I can't get to work..

    I need to count color coded cells, which are colored via condition format.
    I use the VBA script below which I found on the web, but after 3 days of trying and searching how to get this work.. I need your help.

    Goal: I need to have the colored cells ( RED and GREEN) counted monthly and have the result in a different sheet of the workbook.
    So in my workbook attached, the monthly 'SLO Results' colors ( RED and GREEN) should be counted by month and the result is expected in 'sheet 1' in the monthly overview.

    Issue: It looks like the script works..but the counting is not

    This is the script :

    Please Login or Register  to view this content.

    Many thanks for your help !
    Patrick.
    Last edited by PTRK63; 02-01-2021 at 08:45 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    50,935

    Re: Count color coded cells ( formatted conditionally ) in Excel 10

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (Note: this change is not optional. As you are new, I will do it for you today.)

    What do you mean by Excel 10? There is no such version ...
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    6,312

    Re: Count color coded cells ( formatted conditionally ) in Excel 10

    You cannot directly count conditional formatting results from a UDF. If possible, count the original conditions using a COUNTIF formula, as it will be more efficient.
    Rory
    I drink, and I know things

  4. #4
    Registered User
    Join Date
    02-01-2021
    Location
    Brussels
    MS-Off Ver
    2010
    Posts
    6

    Re: Count color coded cells ( formatted conditionally ) in Excel 10

    Thanks for your reply !
    I meant Excel 2010 .

    Is there a way to delete the attached file to replace is by another ?

    Patrick.

  5. #5
    Registered User
    Join Date
    02-01-2021
    Location
    Brussels
    MS-Off Ver
    2010
    Posts
    6

    Re: Count color coded cells ( formatted conditionally ) in Excel 10

    Thanks Rory,
    My understanding was that the only way of counting cell background colors conditionally formatted was via UDF ..But maybe I am wrong..

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    18,810

    Re: Count color coded cells ( formatted conditionally ) in Excel 10


  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    50,935

    Re: Count color coded cells ( formatted conditionally ) in Excel 10

    I meant Excel 2010.
    Thank you - please update your forum profile for clarity.

  8. #8
    Registered User
    Join Date
    02-01-2021
    Location
    Brussels
    MS-Off Ver
    2010
    Posts
    6

    Re: Count color coded cells ( formatted conditionally ) in Excel 10

    I have no idea how to add tags ..

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    50,935

    Re: Count color coded cells ( formatted conditionally ) in Excel 10

    Tags? Nobody has asked you to add tags.

    Go to SETTINGS (top right) and then Edit Profile - change the MS Office version setting to Excel 2010.

  10. #10
    Registered User
    Join Date
    02-01-2021
    Location
    Brussels
    MS-Off Ver
    2010
    Posts
    6

    Re: Count color coded cells ( formatted conditionally ) in Excel 10

    that's clear, done.

  11. #11
    Registered User
    Join Date
    02-01-2021
    Location
    Brussels
    MS-Off Ver
    2010
    Posts
    6

    Re: Count color coded cells ( formatted conditionally ) in Excel 10

    Can you give some more details on how to use the countif formula ?

  12. #12
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    6,312

    Re: Count color coded cells ( formatted conditionally ) in Excel 2010

    You'd need to supply the same criteria that are being used in the conditional format.

+ 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: 10
    Last Post: 12-31-2020, 02:52 AM
  2. Replies: 10
    Last Post: 11-24-2018, 09:54 PM
  3. need a macro to convert conditionally formatted cells color to excel colors.
    By efi007 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-11-2015, 06:39 AM
  4. Count conditionally formatted cells in excel
    By katiejessop in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-17-2013, 11:19 AM
  5. [SOLVED] How To Count Conditionally Formatted Cells
    By ScotyB in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-16-2013, 07:51 PM
  6. [SOLVED] count conditionally formatted cells
    By littlefoot in forum Excel General
    Replies: 5
    Last Post: 07-12-2012, 08:40 AM
  7. Replies: 1
    Last Post: 08-02-2006, 10:45 AM

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