|
本帖最后由 nhrenli 于 2016-11-15 10:32 编辑
请老师在图表中3位数合,等于J1,K1,L1,时,标注不同颜色
本帖最后由 爱疯 于 2016-11-15 17:11 编辑
Sub test()
Dim A, i, j, k, t
Cells.Interior.ColorIndex = 0
'1)填充样式
For k = 10 To 12
Cells(2, k).Interior.ColorIndex = Cells(2, k) + 30 '+30只为效果好看
Next k
'2)填充数据
A = [a1].CurrentRegion
For i = 1 To UBound(A)
For j = 1 To UBound(A, 2)
t = he(A(i, j))
For k = 10 To 12
If Cells(2, k) = t Then
Cells(i, j).Interior.ColorIndex = t + 30: Exit For
End If
Next k
Next j
Next i
End Sub
'功能:求合
Function he(x) As Integer
Dim i, y
For i = 2 To 0 Step -1
y = x \ 10 ^ i
x = x - y * 10 ^ i
he = he + y
Next i
he = Right(he, 1)
End Function
(, 下载次数: 2)
|
|