Counting Conditional Filtered (By Color) Cells

[Guest]

I am using the conditional filter to color a cell blue if a given condition
exists.

Is it possible for a formula to "Count" the number of cells that are blue
over a given range ?

Thank you in advance

 

[Peo Sjoblom]

Use the same criteria that you use for conditional formatting and countif,
so if you format cells greater than 5

=COUNTIF(A2:A200,">5")

as an example


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Bob Phillips]

Maybe take a look at http://www.xldynamic.com/source/xld.CFConditions.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[michael.a7]

The following website might help
http://www.excelexchange.com/

 

[Bob Phillips]

I think he wants to count conditionally formatted colours, not just manually
formatted colours.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)