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