View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default display lowest values

"climate" wrote:
.. it's not works, when run it, locks computer ..


Sorry to hear that. FWIW, here's a working sample which illustrates:
http://www.freefilehosting.net/download/NDkzNzY=
Display lowest values CF.xls

Note: Do not click direct on the link if you're reading this from MS'
webpage. Do a copy n paste of the entire link, inclusive of the trailing "=",
into your browser address bar.

.. and i want to display 10 lowest values in different color.


The normal CF functionality limits it in xl2003 (my ver), to 3
conditions/colours. Hang around awhile for possible responses from others.
Good luck!
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---