Compare different cells on one row and highlight the lowest one

Hi there,

I'm having trouble to figure out how to solve the below. Attaching an example file for reference.

I have a table with one main Supplier (SUPPLIER1) who can provide me certain tree types (Tree A, Tree B, Tree C) and has a specific quantity of each, offered at a specific single price.

I also have (or might have) also more Suppliers (Supplier2, Supplier3, Supplier4, Supplier5 max till Supplier6) who can provide me some of the same tree types but on different single price depending on the quantity available.

My goal is the following = when I enter the single amount for a specific tree (e.g. Tree A, Row11) provided by a certain Supplier or more Suppliers (different than the main Supplier1) to find the lowest single price among all available single prices (and if possible to bold it and highlight it in green color)
From the file attached this should refer to the following - Row11, Cell H11, Cell M11, Cell Q11, Cell U11, Cell Y11, Cell AY11

Also it would be good, again when possible the respective Supplier that offers the lowest price to be somehow highlighted.

(Respectively the highest single price among all to be found and highlighted in red color)

Any ideas are welcome

Is this for Excel 365 or 2016? Your forum profile is confusing.

I have made some changes in the table for simplifying the formula and there should be uniformity in data for all suppliers. Still Code1 columns are redundant for each supplier I feel.
In E11

Formula:

Please Login or Register  to view this content.

In F11

Formula:

Please Login or Register  to view this content.

Maybe this conditional formatting formula (no layout changes):

=AND(E$6="Single Price",E11=AGGREGATE(15,6,$E11:$AD11/(($E$6:$AD$6="Single Price")*($E11:$AD11<>"")),1))