Find the lowest value in a row
 

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?

Find the lowest value in a row
 

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?

Find the lowest value in a row
 

Hi,

Select your cell; in my case A1 to E1 and then
Format|Conditional format
Formula is
=A1=MIN($A$1:$E$1)
Pick a colour
OK

Mike

"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?