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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]>
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" <[email protected]>
> 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!
>
>