I'm creating a worksheet for my DIY deck project
I have material list with 4 lumberyards in my area
My plan is to get prices for each item from the yard.

After I enter the price for each item - I need a function or
conditional formatting that will highlight the lowest priced for that
item.


So if I have in Row 2
Col E = 1.25
Col F = 1.26
Col G = 1.09
Col H = 1.25

I need the cell at Col G highlighter