Macro to highlight value of cheapest supplier ?

[makinmomb]

abc xyz zyz
100 90 80 zyz
50 60 70 abc

Have a formula that quotes the supplier at
cell D2 , is there a macro that will highlight
the minimum value each line that is 80 and
50 to be highlighted

Yes I know =min(a2:d2) will do the work

[stnkynts]

Here is one way to do it:

Please Login or Register  to view this content.

[makinmomb]

Yes , would imagine how automated that would
be if had real raw data going on it , thanks