MIN Formula Help

[Guest]

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.

 

[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