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

Assuming you want to highlight the cell in row 1;
Select Cells E1:G1
Use the following formula in conditional formatting FORMULA IS
=E1=MIN(E:G1) and choose the format you want to highlight

"steve1040" wrote:

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