Count

L

Loi

Hi,

I have a total column and use format condition.

Ex: If a number is =>90,it will change to red color
If a number is <90, it will change to green color.


At the end of sheet, I would like to have a total of red
and green.

Ex; 25 red and 15 green (just count, not a value of cell)

Thank you
Loi
 
F

Frank Kabel

Hi
use
=COUNTIF(A:A,">=90")
and
=COUNTIF("A:A"<90")

It would be VERY difficult to evaluate the conditional format colors
 
Top