These two colors give professional look to your excel sheet.
Range("D2").Interior.color = RGB(245, 245, 245) 'white smoke
Range("D3").Interior.color = RGB(220, 220, 220) 'gainsboro
white color can obtained by below RGB value
Range("D4").Interior.color = RGB(255,255,255) 'white color
Black color can be obtained by below RGB value
Range("D4").Interior.color = RGB(0,0,0) 'black color