+ Reply to Thread
Results 1 to 5 of 5

Count colored cells for conditional formatting

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,803

    Count colored cells for conditional formatting

    Hello everyone
    I have the following UDF function that counts the colored cells for conditional formatting cells
    It works well for only ranges of one column but gives incorrect results with ranges of more than two columns
    Please Login or Register  to view this content.
    I appreciate any help with this issue
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,803

    Re: Count colored cells for conditional formatting

    Any idea about that ?

  3. #3
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,528

    Re: Count colored cells for conditional formatting

    Here's a sub you can use.
    Unfortunately display format doesn't work with a UDF.
    I tried calling the sub from a function but that doesn't work either.
    Try it out.
    If you aren't familiar with display format you will learn something here. Maybe you are and that's why you are not using it in your function since it doesn't work in a UDF.

    Please Login or Register  to view this content.
    As a reminder, once your original request has been fulfilled please mark this thread as SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

    If you are happy with my help, then please consider clicking the add reputation button in the lower left hand corner of this post.

  4. #4
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,528

    Re: Count colored cells for conditional formatting

    Okay try this.

    Please Login or Register  to view this content.
    Last edited by skywriter; 11-08-2015 at 12:26 AM.

  5. #5
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,803

    Re: Count colored cells for conditional formatting

    Mr. Bruce (skywriter)
    you are awesome ..at last solved this issue
    I spent two hours yesterday trying to solve it but all tries failed .

    Thanks a lot for this great help
    Regards
    Last edited by YasserKhalil; 11-08-2015 at 12:32 PM.

+ 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. [SOLVED] Conditional Formatting - Dates to be Colored on Calendar
    By ExcelSponge in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-28-2015, 07:17 PM
  2. Replies: 4
    Last Post: 07-18-2015, 11:13 AM
  3. Replies: 1
    Last Post: 11-09-2013, 02:43 AM
  4. Count Cells colored by conditional formatting
    By sam99 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-19-2013, 02:58 PM
  5. [SOLVED] Conditional Formatting with Colored Arrows
    By garrett.grillo in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-21-2013, 09:24 PM
  6. 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
  7. conditional formatting and colored cells
    By henro8 in forum Excel General
    Replies: 9
    Last Post: 07-10-2008, 03:12 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