Counting conditional format

  • Thread starter Thread starter HJ
  • Start date Start date
H

HJ

I have used conditional formatting to highlight numbers
in a column [8000 rows] that match a given criteria. Is
there any way to generate a count for the number of cells
that are highlighted?
 
What's the criteria, use the same criteria in a countif

If your high lighted numbers were >250

=COUNTIF(A2:A8000,">250")
 
The conditional format compares each number with a
corresponding number in another column - row by row, ie
E6>F6, E7>F7..., so there isn't a single criteria for
COUNTIF.
-----Original Message-----
What's the criteria, use the same criteria in a countif

If your high lighted numbers were >250

=COUNTIF(A2:A8000,">250")



--

Regards,

Peo Sjoblom


I have used conditional formatting to highlight numbers
in a column [8000 rows] that match a given criteria. Is
there any way to generate a count for the number of cells
that are highlighted?
Click to expand...


.
Click to expand...
 
You could use
=SUMPRODUCT(--(E1:E100>F1:F100))
Change ranges to suit

--
Regards
Roger Govier
The conditional format compares each number with a
corresponding number in another column - row by row, ie
E6>F6, E7>F7..., so there isn't a single criteria for
COUNTIF.
-----Original Message-----
What's the criteria, use the same criteria in a countif

If your high lighted numbers were >250

=COUNTIF(A2:A8000,">250")



--

Regards,

Peo Sjoblom


I have used conditional formatting to highlight numbers
in a column [8000 rows] that match a given criteria. Is
there any way to generate a count for the number of cells
that are highlighted?
Click to expand...


.
Click to expand...
Click to expand...
 
I think this will do it..thanks!!
-----Original Message-----
You could use
=SUMPRODUCT(--(E1:E100>F1:F100))
Change ranges to suit

--
Regards
Roger Govier
The conditional format compares each number with a
corresponding number in another column - row by row, ie
E6>F6, E7>F7..., so there isn't a single criteria for
COUNTIF.
-----Original Message-----
What's the criteria, use the same criteria in a countif

If your high lighted numbers were >250

=COUNTIF(A2:A8000,">250")



--

Regards,

Peo Sjoblom


I have used conditional formatting to highlight numbers
in a column [8000 rows] that match a given criteria. Is
there any way to generate a count for the number of cells
that are highlighted?


.
Click to expand...
Click to expand...


.
Click to expand...
 
Peo said:
It won't work for conditional formatting..


Frank Kabel said:
HJ said:
I have used conditional formatting to highlight numbers
in a column [8000 rows] that match a given criteria. Is
there any way to generate a count for the number of cells
that are highlighted?
Click to expand...

Hi
one way: have alook at the following site to count cell colors
http://www.cpearson.com/excel/colors.htm

Frank
Click to expand...
Click to expand...

Hi Peo
thanks for the info. Didn't know that
Frank
 
Back
Top