Use this:
=A1=MIN(A:A)

Great resource he
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Regards,
Ryan---

--
RyGuy


"jlo" wrote:

I have a spreadsheet that has several Price fields per Vendor. I want to use
conditional formatting to find the lowest value in the three Price fields for
each record so I can color code the lowest value. Does anyone know how to
write the formula?