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.
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.