Question on conditional formatting, it was sort of resolved in a few other posts but not fully to what I.

I have a restaurant workbook, weekly I input prices between 20 or so vendors.

I would like to be able to put the prices in and have what ever cell is the lesser value be highlighted yellow, so it would be the ideal vendor / product to purchase from that week as its in yellow.

Example:

vender A, Vender B, Vender C all sell carrots. Vender A is at $00.94 per pound, Vender B is $00.88 and C is $00.64. After imputing these prices into the charts vender C would automatically be highlighted yellow as its the cheapest.

any thoughts?

I attempted to do =min between the cells in the conditional formation but no luck, but maybe i'm doing it wrong as well.

*update 1.23.2012 currently I am doing conditions for greater then "x,Y,Z" leaves cell blank, Less then "x,y,Z" leaves cell yellow. But this takes forever, and I have some 600 items. Also when I add items to this list it will moves cells around to keep things in "ABC" order, is there a way to lock conditions to cells even if they move?

thanks