How to find lowest value in row

  • Thread starter Thread starter steve1040
  • Start date Start date
S

steve1040

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
 
Back
Top