Find minimum value for each row based on selected columns and highlight the lowest value

[weijianhk]

I would like to seek some help on the problem that I'm facing. I'm trying to highlight the lowest value in the sheet for each row based on selected columns, i.e. iot1, iot2, iot3. If you see the before and after image below, I would like to get some assistance on how to highlight the lowest (minimum) value. Thank you very much, any assistance is much appreciated!


Before
https://ibb.co/c27kmd


After
https://ibb.co/ego2XJ

Many thanks for helping me out! I managed to run my code such that it can highlight the lowest value across each row, which means that it compares the value of all columns within a single row. I'm not able to overcome that though, I'm grateful with any help rendered! Thanks.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...-selected-columns-highlight-lowest-value.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it.
Please be patient and do not attempt to post the question again.