The following line changes the fill color of all the cells in sheet 2 to blue:

Sheet2.Cells.Interior.Color = vbBlue

Same as the previous line but instead of using the blue color constant it uses the blue color code

Sheet2.Cells.Interior.Color = 16711680

For more information about working with colors in VBA for Excel please see VBA Excel, Colors.

Before:

After:

See Also:

•  Excel VBA, Cell Fill Color
• Excel VBA, Formatting Cells and Range Using the Macro Recorder

If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. Also please visit my website www.software-solutions-online.com