Lowest number in a row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to highlight the lowest number in a row ONLY if the number is less than the value in the first column of the spreadsheet

I am trying to highlight the lowest price only if it is lower than our price

Is this possible?
 
Jim,

Just to make sure I understand you correctly, if your data were

1 2 4 3 6
nothing should be highlighted
3 2 4 3 6
the 2 should be highlighted

Select the Data (as many rows as you like but skipping the first column)
ie select B1:L12

Format -> Conditional Formatting
Formula Is =AND(MIN($B1:$L1)<$A1,B1=MIN($B1:$L1))

This formula will adjust itself for each cell.

Dan E
 
Back
Top