Highlight smallest cell in row

[cableghost]

I would like a rule that is applied to the entire row; one in which the cell with the smallest number value is highlighted.

I tried a conditional format, but it is being applied to all cells in the row (see attached).

[FDibbins]

2 things...
1. make that <$B49
2. post a sample workbook, not a pic

Also, if B49 will not always be the smallest, try using MIN() or small()

[cableghost]

Thanks for the quick response, @FDibbins. I'm not certain how to use MIN() or small() in such a case.

I have attached a sample workbook. In the sample, I would like the cell with the lowest value in row 2 to be highlighted, i.e. F2 (12000).

The idea here is to have some viausl reference of the lowest cell value. If it's possible just to present that value in another cell, that would be okay. Something like...

Lowest value in row 2: 12000

[ChemistB]

Select the row (or rows)
New Rule>Use formula
=B2=MIN($B2:$I2)

[cableghost]

Thanks @ChemistB, though that formula highlights the cell prior to the lowest valued cell.

[FDibbins]

Worked fine for me. Did you use the range EXCLUDING the row headings (column A)?

[cableghost]

Worked fine for me. Did you use the range EXCLUDING the row headings (column A)?

I don't see an option to specifically exclude columns in Conditional Formatting...where is this setting?

[FDibbins]

It's not a setting, its under the "applies to" window, to the right of the rule. Make sure the range there starts in B

[lornaerland]

sample_book cableghost.xlsOk I am no expert but what worked for me was to highlight the entire row, select Top/Bottom Rules in conditional formatting. Then select Bottom 10 Items and change the number in the scroll box to 1. That will quickly find the lowest cell in the row.

[FDibbins]

Another good option, lornaerland

[ChemistB]

Yep, your way works.

Why my way probably didn't work for you, you probably selected the entire row. If that's the case, then the formula would be
=B1=MIN($B1:$ZZ2) or something like that. The single cell referred to should be the active cell of the range you selected.

[cableghost]

Thank you all.

[sktneer]

If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.