Find the lowest value in a row

  • Thread starter Thread starter jlo
  • Start date Start date
J

jlo

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?
 
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
 
Back
Top