How to Add Shading to Cells in a Numbers Spreadsheet
Click in or drag across the cells, rows, or columns you want to format.
The cells appear highlighted. You can use the scroll bars to navigate in the spreadsheet.
Click the Inspector toolbar button.
The Inspector opens.
Click the Graphic Inspector button in the Inspector toolbar.
Numbers displays the settings.
Click the Fill pop-up menu.
Select a shading option.
Click the color box to select a color for your shading.
Numbers displays a color picker. Click to select a color.
Click the Close button in the color picker. Click the Inspector’s Close button.
You return to the spreadsheet with the shading and colors you chose applied.