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.