This may be really obvious but I can't think how to set this up.
I have a spreadsheet with names down the left and products across the top. I have the price in the corresponding cell for the name and the product.
For the name row, I want to highlight the lowest cost in a different colour...