Count coloured cells

[pamaga]

Let's see if I can explain this properly...
I have a large number of data in column A. This is conditionally formatted so that cells below a certain threshold (value in B1) are green, above another threshold (value in B3) are red, and cells between the two values are orange. Now, what I would like to do is count the number of cells in column A that are green, orange and red, and put these values in C1, C2 and C3.
Did I explain this clearly? Many thanks for your help.

 

[Ivan F Moala]

On 2002-09-18 02:42, pamaga wrote:
Let's see if I can explain this properly...
I have a large number of data in column A. This is conditionally formatted so that cells below a certain threshold (value in B1) are green, above another threshold (value in B3) are red, and cells between the two values are orange. Now, what I would like to do is count the number of cells in column A that are green, orange and red, and put these values in C1, C2 and C3.
Did I explain this clearly? Many thanks for your help.

You will need to use your criteria formulas for the conditional formating in a countif formula to text fot the conditions.

eg if Green > 200 then

Countif (yourrange,yourcondition)

etc