MIN Formula Help

P

Peter Pappas

I have a 'bid list' where I can cut and paste my four different vendors
supply price list into our major list, and what I'd like to do is use a min
function at the end of that row to not only return the lowest number, but
also to either format that cell with the lowest number so that we can easily
see who has the lowest price. My data are arranged beginning on row 11, with
vendor 1 in E, 2 in F and so on with my min function at the last column. I
tried the conditional formatting but it didn't seem to work with just a row,
the previous post referred to a matrix.
 
B

Biff

Hi!

Try this:

Assume the range, including the cell with the MIN formula,
is E11:J11 (J11 holding the MIN formula)

Select the range E11:J11.
Conditional formatting
Formula is: =AND(E11>0,E11=MIN($E11:$J11))
Select your format styles
OK out

Biff
 

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

Top