手工设置excel单元格背景色,通过录制宏,可以发现一行关键代码:
Selection.Interior.ColorIndex = 27
这些数值代表哪种颜色,这些颜色范围是多少?
我编写了一个简单VBA代码来测试一下
为方便对照,我把颜色值和对应颜色左右分列,然后分三栏布局
Sub 设置Interior背景色()
Set ws = Sheets(1)
ws.Range("A1:F1").Merge
ws.Cells(1, 1) = "Excel单元格颜色colorindex值对应表"
ws.Cells(1, 1).HorizontalAlignment = xlCenter
acolor = 0
r = 2: c = 1
Do
ws.Cells(r, c) = acolor
ws.Cells(r, c + 1).Interior.ColorIndex = acolor
r = r + 1
If r > 20 Then
r = 2
c = c + 2
End If
acolor = acolor + 1
Loop Until acolor > 56
End Sub
运行以上代码,可以得到如下表格