Function question

[Dale Rosenthal]

I know I'm not going to ask this correctly. I have a column of numbers. I
wish to have a count at the bottom of the column of the number of numbers
that fall below a certain number. What function is this? Or, is there a
website that would tell me how to do this?

Second question: Same column of numbers. Is there a way to have those same
numbers that fall below a given number become bold?

Thanks so much.

Dale

 

[CLR]

This formula will count all the numbers in column A below 10
=COUNTIF(A:A,"<10")

Conditional Formatting will bold those numbers...........Format >
Conditional Formatting > then follow the menu.........

Vaya con Dios,
Chuck, CABGx3

 

[Roland]

Dale,

The answer to your first question is that the COUNTIF function appears to
be what you are looking for.

For the second question, conditional formatting is your key. It's at
Format>Conditional Formatting.

 

[RagDyer]

See answers to your other post in "newusers".

Please don't multipost.
Most folks here read all the NGs
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

I know I'm not going to ask this correctly. I have a column of numbers. I
wish to have a count at the bottom of the column of the number of numbers
that fall below a certain number. What function is this? Or, is there a
website that would tell me how to do this?

Second question: Same column of numbers. Is there a way to have those same
numbers that fall below a given number become bold?

Thanks so much.

Dale

 

[Dale Rosenthal]

To those who helped,

Thanks so much. My wife and I got the Countif function earlier but the
conditional formatting was spot on. Thanks again.

Dale

On 1/24/05 6:45 PM, in article