Results 1 to 4 of 4

Thread: Color cell count

  1. #1
    Neophyte sumanc6's Avatar
    Join Date
    Jul 2019
    Posts
    1
    Articles
    0
    Excel Version
    2013

    Color cell count



    Register for a FREE account, and/
    or Log in to avoid these ads!

    please guide me

    there is any formula to count how many colored cell in every row??
    Attached Files Attached Files

  2. #2
    Conjurer alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    184
    Articles
    0
    Excel Version
    2019
    Use the Countif function to count and use the same criteria you used to conditionally format the cells. Look at this link https://www.techonthenet.com/excel/formulas/countif.php

  3. #3
    Conjurer alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    184
    Articles
    0
    Excel Version
    2019
    In AF2 =COUNTIF(B2:AD2,">" &0.437847222222222) and copy down

  4. #4
    Neophyte ges's Avatar
    Join Date
    Jul 2019
    Location
    Italy
    Posts
    3
    Articles
    0
    Excel Version
    2016
    Hi,
    the colors are givin by conditional formatting:
    Code:
    Function count_Color(rng As Range) As Integer    
    Dim cl As Range
        For Each cl In rng
            count_Color = count_Color + cl.FormatConditions.Count
        Next
    End Function

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •