Forum Discussion

aa aaaa's avatar
aa aaaa
Tin Contributor
Sep 05, 2018

count the number of colored cells which conditionally formatted by "Top 10 Items"

In this file, i want to count the number of colored cells which conditionally formatted by "Top 10 Items".

There are some solution for counting cells which conditionally formatted by formula, but nothing for my problem. would you please help me?

Thank you.

Macros and VBA

5 Replies

    • aa aaaa's avatar
      aa aaaa
      Tin Contributor
      Sep 05, 2018

      Thank you, but I want to insert formula in column M, and count colored cells in each row.

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Sep 05, 2018

        Sorry. When straightforward way

        =(L2>=LARGE(L$2:L$23,10))+
(K2>=LARGE(K$2:K$23,10))+
(J2>=LARGE(J$2:J$23,10))+
(I2>=LARGE(I$2:I$23,10))+
(H2>=LARGE(H$2:H$23,10))+
(G2>=LARGE(G$2:G$23,10))+
(F2>=LARGE(F$2:F$23,10))+
(E2>=LARGE(E$2:E$23,10))+
(D2>=LARGE(D$2:D$23,10))+
(C2>=LARGE(C$2:C$23,10))+
(B2>=LARGE(B$2:B$23,10))

        not sure right now how to compact.

        Attached.