Cell fill colors are often useful if you have a long sheet - vary the fill color of every second line (or every few lines) to make your sheet easier to read. Fill colors are also useful for highlighting important information in your sheet.
To change the fill color or fill pattern of cells:
Select the cell(s) that you want to format.
Go to the Format menu, and click Cells.
A Format Cells window will appear.
Click the Patterns tab.
Here, you can:
Select a cell Fill Color (as opposed to the normal white cell color).
If you would like the cells to be filled with a pattern, select a Fill Pattern, and a Pattern Color.
When you are finished, click OK
The fill color will be applied to the selected cell(s).
Cell Fill Color in Advanced Mode
To change the fill color of cells in Advanced Mode:
Select the cell(s) that you want to format.
Click the down arrow on the Fill Color icon (shown below).
A palette of colors will appear. Click a color to select it. Or, click More Colors to create your own custom color.
The fill color of the selected cell(s) will be change to the color you chose.