Counting Conditional Filtered (By Color) Cells
 

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

Counting Conditional Filtered (By Color) Cells
 

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


"carl" wrote in message
...
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

Counting Conditional Filtered (By Color) Cells
 

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"carl" wrote in message
...
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

Counting Conditional Filtered (By Color) Cells
 

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


--
michael.a7
------------------------------------------------------------------------
michael.a7's Profile: http://www.excelforum.com/member.php...o&userid=33027
View this thread: http://www.excelforum.com/showthread...hreadid=530528

Counting Conditional Filtered (By Color) Cells
 

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)

"michael.a7" wrote
in message ...

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


--
michael.a7
------------------------------------------------------------------------
michael.a7's Profile:
http://www.excelforum.com/member.php...o&userid=33027
View this thread: http://www.excelforum.com/showthread...hreadid=530528