Thankyou for your prompt reply.
Works perfectly and I've learned something to boot.
Kind regards

-----Original Message-----

Select your range A8:A20
click FormatConditional format

In the first box: formula is
in the 2nd box: =A8=SMALL($A$8:$A$20,1)

Click the format click on the Color box and click on
red


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

.