counting cells with conditional formatting applied

[Guest]

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!

 

[Bernard Liengme]

Look on Chip's site at www.cpearson.com
best wishes

 

[Gord Dibben]

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

 

[Guest]

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.