Look on Chip's site at www.cpearson.com
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"HalB" wrote in message
...
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!