min function trouble

[riccifs]

Hi to the N.G.,
I was trying to insert this code =min(if(A1:A200>10,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.

 

[Bob Phillips]

sTEFANO,

tRY THIS

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

--
HTH

Bob

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

 

[riccifs]

sTEFANO,

tRY THIS

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

--
HTH

Bob

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

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$200>10

what I'm wrong?
Bye,
Stefano.

 

[riccifs]

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$200>10

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.

 

[Bob Phillips]

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)