Forum Discussion
aa aaaa
Sep 05, 2018Copper Contributor
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 no...
aa aaaa
Sep 05, 2018Copper Contributor
Thank you, but I want to insert formula in column M, and count colored cells in each row.
SergeiBaklan
Sep 05, 2018Diamond Contributor
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.