counting cells with conditional formatting applied
 

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!

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!

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!

Thanks for the response.

The problem is I am having trouble understanding how to check a range of
cells. For instance, Column A contains 18 rows with different values, Column
B contains 18 rows of different values that have conditional formatting
applied based on their comparison to Column A (Red = <) or (Green = ). I am
looking to count the number of times Column B is formatted Red.

Example:

A B
1 4 4
2 4 3 (Red)
3 3 4 (Green)
4 5 4 (Red)
5 3 3
...
19 2 === The result I am looking for.


"Gord Dibben" wrote:

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!