hello, i have an invertory worksheet that tracks year round use.
i now would like to compare the prices of an item in a row with the prices
of 5 different collums ( companies). i enter the costs of each item in each
row of each under the collum of each company.

i now have it set up that a seperate colum will show the cheapest price
using the "min" funnction.. but i would realy like the cheapest price show
up as a different color in it's own colum.. in other words.. the roll of
"foil" under competitor 2 is the cheapest so the cell is red with white
letters.

thank you if any one could help.. john