Changing background colors in Excel VBA is easy. Use the Interior ... The code line below sets the background color of cell A1 to light blue. Range("A1").Interior.
www.excel-easy.com