format condition with horizon number, highlight with smallest

Dear Excel help,

I am struggling with format condition of item according to comparison as example.

product A have 4 supplier so I would like to use format condition to highlight on the lower item.

you may refer to attached sample using manual highlight for your ref.

Thanks & deeply appreciated for your supportive.

Select all the cells in the range $E$3:$H$9 and remove the manual background colours, then with the same range selected, click on Conditional Formatting | New Rule | Use a formula... , and put this formula in the dialogue box which pops up:

=E3=MIN(IF($E3:$H3>0,$E3:$H3))

Click on the Format button | Fill tab and choose your background colour, then OK your way out.

You may need to use semicolons ( ; ) instead of commas ( , ) in the formula, depending on your regional settings.

Hope this helps.

Pete