Highlight smallest cell in row

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()

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

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

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

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

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.

Another good option, lornaerland

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.

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.