......A.....B.....C.....D
1..22....15....29...30

=SMALL(A$1:D$1,ROWS(A$1:A1))

Copy down a total of 3 cells.

Note that if there aren't at least N numbers in the range you'll get errors.

This formula makes sure there are enough numbers:

=IF(COUNT(A$1:D$1)=ROWS(A$1:A1),SMALL(A$1:D$1,ROW S(A$1:A1)),"")

--
Biff
Microsoft Excel MVP


"jerminski73" wrote in message
...
I would like to do this same function only I want to grab the three lowest
values. Any ideas?

"Smallest value cell change color" wrote:

If I have four cells, and I want the one with the smallest value change
color automatically.