Hi max
it's not works,when run it, locks computer,and i want to display 10 lowest
values in different color.
Than'ks

"Max" wrote:

One play to try ..

Assume the source matrix is in Sheet1!$A$1:$CV$16071

Click Insert Name Define,
then input it as:

Names in workbook: SmallR
Refers to:
=SMALL(Sheet1!$A$1:$CV$16071,{1;2;3;4;5;6;7;8;9;10 })

Then type the source matrix range in the namebox: A1:CV16071
press Enter to select the matrix with A1 active

Click Format Conditional Formatting
Apply the settings below using Formula Is:

Condition 1:
=ISBLANK(A1)
Format Blue

Condition 2:
=ISNUMBER(MATCH(A1,SmallR,0))
Format Brown
Click to OK out

The above will conditionally format all blank cells in the matrix with blue
fill, and all cells matching the ten lowest values with brown fill.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"climate" wrote:
I have a matrix( 16071 * 100), many of it's cells are empty(blank). i want to
recognize ten lowest values and display with different color on that matrix.
And, empty cells not equal to zero"0",any help will be greatly appreciated.