Hal

You should be able to count the cells based upon the condition that turned the
cells red.

e.g. CF Cell Value is 50 turn red.

Enter formula in a cell =COUNTIF(A1:A100,"50")


Gord Dibben Excel MVP

On Sun, 20 Feb 2005 07:41:05 -0800, "HalB"
wrote:

I am looking for a way/formula that will count the number of times a cell
with conditional formatting has occured.
I have a column of cells that is compared to another column of cells and if
one condition is met (<), the cell's color is set to Red or if another
condition is met () the cell's color is set to Green. I am wanting to add a
column that gives me the total number of Red cell's in that column.

Thanks!