Thanks for the reply Nick.
I am having trouble with the highlighting portion of the post. My data is in
E2 thru E21 and when I enter your formula it only highlights E3 thru E12
regardless of the number hierarchy.

What I am trying to do is, highlight the lowest 10 of the 20 numbers in the
column. I double checked everything and the formula is entered as shown in
the post.

The formula you gave for the finding and posting of the lowest 10 of 20
numbers worked with the mod (A1)) at the end. Look at Mikes reply and it will
show that. Not sure why it works that way, but that is why I'm here to learn.

Thanks again for any help you can give on this.

Dan

--
shredder


"Niek Otten" wrote:

In F1:

=SMALL($E$1:$E$20,ROW())

Copy down to F10

For highlighting Column E:

Select E1:E20

FormatConditional Formatting

Choose Formula is

enter this formula

=COUNTIF($E$1:$E$20,F1)

Click Format

On the Patterns tab, select a background color.

Click OK several times

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"shred77" wrote in message ...
| Seeing all the Excel experts out here is giving me hope to solve this.
| I am trying to find the 10 lowest (and if possible highlight them) of 20
| numbers in a column and enter the results in the next column to the right.
|
| There will be 6 columns total and 20 rows.
| ADate BData Cdata Ddata Edata FData
|
| The E Column is where I am looking to find the lowest 10 of 20 numbers
| and the F Column is where I am looking to put those results.
|
| Thank you in advance for any help you can give.
|
| Dan
|
|
| --
| shredder