Home > VBAUsefulCodes
Using the Interior.ColorIndex property we can fill colors in excel cells. It will be very useful when you want to highlight specific cells like heading etc.
Fill Color In Excel Cells Using VBA
Using the Interior.ColorIndex property we can fill colors in excel cells. It will be very useful when you want to highlight specific cells like heading etc.
Sub Range_Fill_Color()
'Using Cell Object
Cells(3, 2).Interior.ColorIndex = 5 ' 5 indicates Blue Color
'Using Range Object
Range("B5").Interior.ColorIndex = 7
End Sub
Sub Print_Color_Index_Colors()
Dim iCntr
For iCntr = 1 To 56
Cells(iCntr, 1).Interior.ColorIndex = iCntr
Cells(iCntr, 1) = iCntr
Next iCntr
End Sub
Sub Range_Fill_Color_RGB()
'Using Cell Object
Cells(3, 2).Interior.Color = RGB(0, 0, 250)
'Using Range Object
Range("B3").Interior.Color = RGB(0, 0, 250)
End Sub
Subscribe
More to Explore
Tags
VBA Outlook KPI Excel Alt+F11 Dashboards Macros Recording Graphs Automation Developer WaterFall Powerpoint Charts Pivot Tables Forecast Charts