Lowest number in a row

[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?

 

[Dan E]

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