是要这个效果吧?用VBA吧
- Sub 按钮1_Click()
- Dim arr, brr, i&, x&, Rng As Range
- On Error Resume Next
- Set Rng = Application.Intersect(ActiveSheet.UsedRange, Application.InputBox("选择数据区域", , , , , , , 8))
- If Rng.Count < 2 Or Rng.Columns.Count <> 2 Then Exit Sub
- For i = 1 To Rng.Rows.Count
- If Rng(i, 2) <= 1 Then
- x = 1
- ElseIf Rng(i, 2) <= 2 Then
- x = 2
- Else
- x = 3
- End If
- Rng(i, 1) = Rng(i, 1) & String(x, "*")
- Rng(i, 1).Characters(Start:=Len(Rng(i, 1)) - x + 1, Length:=x).Font.Superscript = True
- Next
- Rng(1, 2).Resize(i - 1).NumberFormatLocal = """(""G/通用格式"")"""
- End Sub