Color cell count

S

sumanc6

New member

Joined

Jul 23, 2019

Messages

1

Reaction score

0

Points

0

Excel Version(s)

2013

• Jul 23, 2019

• #1

please guide me

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

 

Attachments

• Book1.xlsx

  10.8 KB · Views: 6

alansidman

Member

Joined

Oct 1, 2018

Messages

402

Reaction score

6

Points

18

Location

Steamboat Springs

Excel Version(s)

O365

• Jul 23, 2019

• #2

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

 

alansidman

Member

Joined

Oct 1, 2018

Messages

402

Reaction score

6

Points

18

Location

Steamboat Springs

Excel Version(s)

O365

• Jul 24, 2019

• #3

In AF2 =COUNTIF(B2:AD2,">" &0.437847222222222) and copy down

 

ges

New member

Joined

Jul 27, 2019

Messages

5

Reaction score

0

Points

1

Location

Italy

Excel Version(s)

365

• Jul 27, 2019

• #4

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