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

What is the syntax to format a cell?

Range(“<cell reference>”).Font.Bold=<true or false>
Range(“<cell reference>”).Font.Underline=<true or false>
Range(“<cell reference>”).Font.Color=<rgb color>
‘examples
Range(“A1”).Font.Bold=True
Range(“A1”).Font.Underline=true
Range(“A1”).Font.Color=rgbNavy