Conditional Formatting - coloring cells

[Grizzle33]

Hello everyone.

I have a spread sheet that I keep track of freight costs on. I quote four different carriers on each shipment we do, and I would like Excel to highlight the cell with the lowest cost in it. I've been doing this manually, but if it's something that can be done automatically it would be nice.

I found the conditional formatting, but it seems the rule I'm looking for might have to be created?

Thanks in advance.

 

[Grizzle33]

use this instead:

=AND(G2=MIN($G$2:$J$2),G2<>"")

That's the ticket, thank you.