Conditional format Count

M

Michael168

How to count the no of cells when the conditional format comes true. Let
says count by color=red.

Thanks
 
P

Peo Sjoblom

What is your conditional format? Use the same criteria and countif..
Assume that the conditional format is red for >50, then use

=COUNTIF(Range,">50")
 
Top