counting cells with conditional formatting applied

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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
 
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.
 
Back
Top