|
- Sub 林demo()
- Dim zrr '数字转字符
- Dim h As Integer, I As Integer, J As Integer, 一, 二, 三, 四
- h = 19
- With Sheet1
- '++++++++++++++++++转字符
- zrr = .Range("C6:K" & h).Value
- For I = 1 To UBound(zrr)
- For J = 1 To UBound(zrr, 2)
- zrr(I, J) = "'" & zrr(I, J)
- Next
- Next
- .Range("C6:K" & h) = zrr
- '+++++++++++++++++++++设置字体颜色
- For I = 6 To h
- 一 = .Range("C" & I).Characters(1, 1).TEXT
- 二 = .Range("C" & I).Characters(2, 1).TEXT
- 三 = .Range("C" & I).Characters(3, 1).TEXT
- 四 = .Range("C" & I).Characters(4, 1).TEXT
- For J = 1 To 7
- '+++++++++++++++++++++D-E设置字体颜色
- If 一 & 四 Like "*" & .Range("D" & I).Characters(J, 1).TEXT & "*" Then
- .Range("D" & I).Characters(J, 1).Font.ColorIndex = 3
- Else
- .Range("D" & I).Characters(J, 1).Font.Color = 1
- End If
- If 一 & 四 Like "*" & .Range("E" & I).Characters(J, 1).TEXT & "*" Then
- .Range("E" & I).Characters(J, 1).Font.ColorIndex = 3
- Else
- .Range("E" & I).Characters(J, 1).Font.Color = 1
- End If
- '+++++++++++++++++++++F-G设置字体颜色
- If 二 & 三 Like "*" & .Range("F" & I).Characters(J, 1).TEXT & "*" Then
- .Range("F" & I).Characters(J, 1).Font.ColorIndex = 3
- Else
- .Range("F" & I).Characters(J, 1).Font.Color = 1
- End If
- If 二 & 三 Like "*" & .Range("G" & I).Characters(J, 1).TEXT & "*" Then
- .Range("G" & I).Characters(J, 1).Font.ColorIndex = 3
- Else
- .Range("G" & I).Characters(J, 1).Font.Color = 1
- End If
- '+++++++++++++++++++++H-I设置字体颜色
- If 一 & 二 Like "*" & .Range("H" & I).Characters(J, 1).TEXT & "*" Then
- .Range("H" & I).Characters(J, 1).Font.ColorIndex = 3
- Else
- .Range("H" & I).Characters(J, 1).Font.Color = 1
- End If
- If 一 & 二 Like "*" & .Range("I" & I).Characters(J, 1).TEXT & "*" Then
- .Range("I" & I).Characters(J, 1).Font.ColorIndex = 3
- Else
- .Range("I" & I).Characters(J, 1).Font.Color = 1
- End If
- '+++++++++++++++++++++J-K设置字体颜色
- If 二 & 三 Like "*" & .Range("J" & I).Characters(J, 1).TEXT & "*" Then
- .Range("J" & I).Characters(J, 1).Font.ColorIndex = 3
- Else
- .Range("J" & I).Characters(J, 1).Font.Color = 1
- End If
- If 二 & 三 Like "*" & .Range("K" & I).Characters(J, 1).TEXT & "*" Then
- .Range("K" & I).Characters(J, 1).Font.ColorIndex = 3
- Else
- .Range("K" & I).Characters(J, 1).Font.Color = 1
- End If
- Next
- Next
- End With
- End Sub
- Sub TEXT()
- MsgBox Range("C6").Characters(1, 1).Font.ColorIndex
- End Sub
复制代码 |
|