counting coloured cells

[michael]

Hi All

Is there a formular that will count the number of cells
which have a given format, i.e. count the number of red
cells in a range?

M.

 

[Anon]

Hi All

Is there a formular that will count the number of cells
which have a given format, i.e. count the number of red
cells in a range?

M.

No. You have to use VBA for this, as described here:
http://www.cpearson.com/excel/colors.htm

 

[Carrie Benett]

What's making the cells red? If ther is a numeric reason
for making them red, I can give you some formulas and
ideas on how to count them. Let me know if you still need
help.

Carrie