You can use the AutoFormat feature to quickly apply a set of cell formats to a sheet or a selected cell range.
- Select the cells, including the column and row headers, that you want to format.
- Choose Format > AutoFormat.
Choosing an AutoFormat
- To select which properties (number format, font, alignment, borders, pattern, autofit width and height) to include in an AutoFormat, click More. Select or deselect the required options.
- Click OK.
If you do not see any change in color of the cell contents, choose View > Value Highlighting from the menu bar.