
'其它方法,行列不限
Option Explicit
Sub abc()
Dim a, i, j, n, p
With [a1].CurrentRegion
a = .Value
.Interior.ColorIndex = xlNone
End With
For i = 2 To UBound(a)
n = a(i, 2): p = 2
For j = 3 To UBound(a, 2)
If a(i, j) < n Then n = a(i, j): p = j
Next
Cells(i, p).Interior.Color = vbYellow
Next
End Sub