I have three columns–Order, Buy, and Craft–and want to identify the minimum value for the row. In the image below, I identify the value in an additional column. I want to avoid the need for the additional column by using conditional formatting to highlight the minimum value.
I have Googled the problem and tried a couple of formulas, but neither one seemed to work correctly.
Can anyone assist?
Best Answer
I'm assuming that your data range is C3:E10.
Write this formula as Formatting Rule.
=IF(C3<>"",C3=MIN($C3:$E3))
.Apply color format of your choice and finish with Ok.
Additionally I would like to suggest the following, which is an optional:
If you want the formatting to stop when there are no values in the row adjust to, then write this formula as formatting Rule.
=AND(COUNT($C3:$E3)<>0,C3=Min($C3:$E3))
N.B. Adjust the cell address as per your need.