Find the lowest value in a row

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

Mike H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Findiing highest and lowest in rows and columns 3
Trying to find additional ranges outside of min, max, and average 2
Maintain lowest value in an "external connection" cell 0
Conditional Formatting using Small 1
Trying to subtract the two lowest values from a row of numbers 4
Changing row background from external program 0
Mail Merge Directory Conditional Page Break 0
Hghlight the best price for each row 5

Top