Conditional format Count

[Michael168]

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

Thanks

 

[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")

 

[Danny]

See Oct. 3, 2003 8:51AM posting in this newsgroup. RE:
Find Cell Color Index

 

[Nishith Desai]

You can easily do this by writting a code in vba.
I think you are working with dates.
I have a file no 3 at www.pexcel.com/download.htm
you can see the code for it .. or write me at
www.pexcel.com i have a condition programmed file for my
own use see if it is helpful to you.

nisth
www.pexcel.com