min function trouble
 

Hi to the N.G.,
I was trying to insert this code =min(if(A1:A20010,A1:A200)) into the
conditional formatting forms. But it doesn't work!
When I copy it into the function bar and press Shift+Ctrl+Enter it
works great and it gives to me the lowest values between the above
range of cells. So I decided to copy it into the conditional
formatting forms to make highlight the cell with the min value. But in
it the function does not work... WHY!?

Please someone help me!
Bye,
Stefano.

min function trouble
 

sTEFANO,

tRY THIS

=A1=MIN(IF($A$1:$A$20010,$A$1:$A$200))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

wrote in message
...
Hi to the N.G.,
I was trying to insert this code =min(if(A1:A20010,A1:A200)) into the
conditional formatting forms. But it doesn't work!
When I copy it into the function bar and press Shift+Ctrl+Enter it
works great and it gives to me the lowest values between the above
range of cells. So I decided to copy it into the conditional
formatting forms to make highlight the cell with the min value. But in
it the function does not work... WHY!?

Please someone help me!
Bye,
Stefano.

min function trouble
 

On 4 Gen, 10:31, "Bob Phillips" wrote:
sTEFANO,

tRY THIS

=A1=MIN(IF($A$1:$A$20010,$A$1:$A$200))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

wrote in message

...

Hi to the N.G.,
I was trying to insert this code =min(if(A1:A20010,A1:A200)) into the
conditional formatting forms. But it doesn't work!
When I copy it into the function bar and press Shift+Ctrl+Enter it
works great and it gives to me the lowest values between the above
range of cells. So I decided to copy it into the conditional
formatting forms to make highlight the cell with the min value. But in
it the function does not work... WHY!?

Please someone help me!
Bye,
Stefano.

Hi Bob,
thanks for your answer.
I tried your function, it works but it just give to me the min value
and not the min if $A$1:$A$20010

what I'm wrong?
Bye,
Stefano.

min function trouble
 

On 4 Gen, 11:47, wrote:
On 4 Gen, 10:31, "Bob Phillips" wrote:



sTEFANO,

tRY THIS

=A1=MIN(IF($A$1:$A$20010,$A$1:$A$200))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

wrote in message

...

Hi to the N.G.,
I was trying to insert this code =min(if(A1:A20010,A1:A200)) into the
conditional formatting forms. But it doesn't work!
When I copy it into the function bar and press Shift+Ctrl+Enter it
works great and it gives to me the lowest values between the above
range of cells. So I decided to copy it into the conditional
formatting forms to make highlight the cell with the min value. But in
it the function does not work... WHY!?

Please someone help me!
Bye,
Stefano.

Hi Bob,
thanks for your answer.
I tried your function, it works but it just give to me the min value
and not the min if $A$1:$A$20010

what I'm wrong?
Bye,
Stefano.

Sorry Bob.... I tried better and It works great!!!
Many many thanks for your help!

I really do appreciate your interest to my problems!
Bye,
Stefano.

min function trouble
 

Glad you got it working Stefano, you had me worried for a minute <bg

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

wrote in message
...
On 4 Gen, 11:47, wrote:
On 4 Gen, 10:31, "Bob Phillips" wrote:



sTEFANO,

tRY THIS

=A1=MIN(IF($A$1:$A$20010,$A$1:$A$200))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

wrote in message

...

Hi to the N.G.,
I was trying to insert this code =min(if(A1:A20010,A1:A200)) into
the
conditional formatting forms. But it doesn't work!
When I copy it into the function bar and press Shift+Ctrl+Enter it
works great and it gives to me the lowest values between the above
range of cells. So I decided to copy it into the conditional
formatting forms to make highlight the cell with the min value. But
in
it the function does not work... WHY!?

Please someone help me!
Bye,
Stefano.

Hi Bob,
thanks for your answer.
I tried your function, it works but it just give to me the min value
and not the min if $A$1:$A$20010

what I'm wrong?
Bye,
Stefano.

Sorry Bob.... I tried better and It works great!!!
Many many thanks for your help!

I really do appreciate your interest to my problems!
Bye,
Stefano.