Easy way to count

[Guest]

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]

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.

 

[Cutter]

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