What is the syntax to fill cell color?

Range(“<cell reference>”).Interior.Color = <rgb color>
Range(“<cell reference>”).Interior.ColorIndex = <color index integer>
‘example
Range(“B3”).Interior.Color = rgbSandyBrown
Sheets("NonActiveSheet").Range("A3:F10").Interior.ColorIndex = 37

For a color index reference sheet, click here.

Advertisements