Counting conditional format

[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?

 

[Peo Sjoblom]

What's the criteria, use the same criteria in a countif

If your high lighted numbers were >250

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

 

[Guest]

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?

.

 

[Frank Kabel]

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?

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

Frank

 

[Roger Govier]

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?

.

 

[HJ]

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?


.

.

 

[Peo Sjoblom]

It won't work for conditional formatting..

--

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?

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

Frank

 

[Frank Kabel]

It won't work for conditional formatting..

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?

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

Frank

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