+ 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
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    78,931

    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!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,854

    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

  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
    22,444

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


  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    78,931

    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
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    78,931

    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
    365 Ent SAC
    Posts
    8,854

    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. [SOLVED] Can I count conditionally formatted red cells in Excel 2000
    By ExcelUser in forum Excel General
    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