is there an easy way after conditional formatting to count colored cells,
e.g., say the cond-formating resulted 10 cells in col A that are red and you
wanted to include that total at end of the analysis, rather than counting
them up manually.
thanks

Easy--no (well, in my opinion).

Chip Pearson has some code you can use to see if it's difficult for you:
http://cpearson.com/excel/CFColors.htm

If I were doing it, I'd try to mimic the same conditional formatting rules in a
cell in the same row--then use that.

reno wrote:

is there an easy way after conditional formatting to count colored cells,
e.g., say the cond-formating resulted 10 cells in col A that are red and you
wanted to include that total at end of the analysis, rather than counting
them up manually.
thanks

--

Dave Peterson

What was the condition that made the cells turn red? You may be able to
count them that way.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=523756