Conditional Formatting

[Jetjefferson]

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 and then roll this through the rest of my sheet.

Can anyone point me in the right direction please?

Thanks

Derek

 

[TomH]

In conditional formatting, enter a formula that indicates if the cell's value is =min(range), apply a format. "Help" on the conditional formatting actually has an exact example of what you're trying to do. I've used it many times myself.

Another way of doing it is picking a cell on the row and making it the min... =min(range) . Then, set your conditional formatting to = the cell address of the min to apply the format.