I have a matrix( 16071 * 100)
when run it, locks computer ..

You're trying to apply cf with multiple conditions to over 1.5 million
cells! That would be my guess as to why the computer locks up.

--
Biff
Microsoft Excel MVP


"Max" wrote in message
...
"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
---