This worksheet is a tabular data. Regular spreadsheet operations like cut/copy/paste, undo/redo, range selection, formulas and formatting are restricted in this mode.
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.
