Background Color Macro
The macro in this spreadsheet demonstrates how to apply solid background color to a cell range including the grid lines (as in Excel). First apply the background color you want to the 1st cell of your target range. Then select your target range and click on the "Apply BG Color" button.