Countif cell color is Red?

  • Thread starter Thread starter JohnG
  • Start date Start date
J

JohnG

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...
 
Thank you.
Added a module, which I never have done before, and it works great.
Appreciate such a quick response. Have a great day !
 
you're welcome and thanks for the feedback

JohnG said:
Thank you.
Added a module, which I never have done before, and it works great.
Appreciate such a quick response. Have a great day !
Click to expand...
 
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
 
Back
Top