Private Sub CommandButton1_Click()
Dim arr, brr(1 To 10, 1 To 1), i%, m%, n%
arr = Range("a1:a10")
For i = 1 To 10
brr(i, 1) = Abs(arr(i, 1) - 6)
Next
For m = 1 To 3
n = Application.Small(brr, m)
For i = 1 To 10
If Cells(i, 1).Font.ColorIndex <> 3 And brr(i, 1) = n Then
Cells(i, 1).Font.ColorIndex = 3
GoTo 100
End If
Next i