Countif cell color is Red?
 

I think I have an easy problem to solve, but I'm no excel guru.
If I have a row of cells, (basically 52 one for each week), in some there is
a conditional format to make the cell red. I am trying to count the number
of red cells in that row. Any quick formula I can insert in a cell like
countif ....?? Thanks

Hi John

Chip Pearson has some code on his website to do this
http://www.cpearson.com/excel/colors.htm

it's about the third article down, "Counting cells with a specific color"

Cheers
JulieD

"JohnG" wrote in message
...
I think I have an easy problem to solve, but I'm no excel guru.
If I have a row of cells, (basically 52 one for each week), in some there
is a conditional format to make the cell red. I am trying to count the
number of red cells in that row. Any quick formula I can insert in a cell
like countif ....?? Thanks

If you're using a conditional format, use a formula with the same
conditional as the CF...

In article ,
"JohnG" wrote:

I think I have an easy problem to solve, but I'm no excel guru.
If I have a row of cells, (basically 52 one for each week), in some there is
a conditional format to make the cell red. I am trying to count the number
of red cells in that row. Any quick formula I can insert in a cell like
countif ....?? Thanks

Thank you.
Added a module, which I never have done before, and it works great.
Appreciate such a quick response. Have a great day !

"JohnG" wrote in message
...
I think I have an easy problem to solve, but I'm no excel guru.
If I have a row of cells, (basically 52 one for each week), in some there
is a conditional format to make the cell red. I am trying to count the
number of red cells in that row. Any quick formula I can insert in a cell
like countif ....?? Thanks

you're welcome and thanks for the feedback

"JohnG" wrote in message
...
Thank you.
Added a module, which I never have done before, and it works great.
Appreciate such a quick response. Have a great day !

"JohnG" wrote in message
...
I think I have an easy problem to solve, but I'm no excel guru.
If I have a row of cells, (basically 52 one for each week), in some there
is a conditional format to make the cell red. I am trying to count the
number of red cells in that row. Any quick formula I can insert in a cell
like countif ....?? Thanks

Hmm...

That doesn't work when the color is applied using CF...

In article ,
"JulieD" wrote:

Chip Pearson has some code on his website to do this
http://www.cpearson.com/excel/colors.htm

it's about the third article down, "Counting cells with a specific color"

Hi JE

you're absolutely correct - sorry, John ... Chip has notes on working with
CF, but i'ld recommend the method suggested by JE McGimpsey about using the
formula/criteria that you're using to generate the conditional formatting in
the first place.

Cheers
JulieD

"JE McGimpsey" wrote in message
...
Hmm...

That doesn't work when the color is applied using CF...

In article ,
"JulieD" wrote:

Chip Pearson has some code on his website to do this
http://www.cpearson.com/excel/colors.htm

it's about the third article down, "Counting cells with a specific color"