Question on conditional formatting, it was sort of resolved in a fe
other posts but not fully to what I.
I have a restaurant workbook, weekly I input prices between 20 or s
I would like to be able to put the prices in and have what ever cell i
the lesser value be highlighted yellow, so it would be the ideal vendo
/ product to purchase from that week as its in yellow.
vender A, Vender B, Vender C all sell carrots. Vender A is at $00.94 pe
pound, Vender B is $00.88 and C is $00.64. After imputing these price
into the charts vender C would automatically be highlighted yellow a
its the cheapest.
I attempted to do =min between the cells in the conditional formatio
but no luck, but maybe i'm doing it wrong as well.
*update 1.23.2012 currently I am doing conditions for greater the
"x,Y,Z" leaves cell blank, Less then "x,y,Z" leaves cell yellow. Bu
this takes forever, and I have some 600 items. Also when I add items t
this list it will moves cells around to keep things in "ABC" order, i
there a way to lock conditions to cells even if they move?