You can highlight data in cells by using Fill Color to add or change the background color or pattern of cells. Here's how: Select the cells you want to highlight. Tip: To use a different background …

You can apply conditional formatting to a range of cells (either a selection or a named range), an Excel table, and in Excel for Windows, even a PivotTable report.

Add or change a fill color Select the cells in which you want to add or change the fill color. On the Table Design tab, click the arrow next to Shading. Click the color you want from Theme Colors …

To fill cells with a custom color, select the arrow next to Fill Color , select More Colors, and then in the Colors dialog box select the color that you want. To apply the most recently selected color, …

There are two ways to apply shading to alternate rows or columns —you can apply the shading by using a simple conditional formatting formula, or you can apply a predefined Excel table style …

You can choose from the Sequential (2-color) option, which is the default color setting, or the Diverging (3-color) option. You can experiment with changing the Minimum, Midpoint and …

For each theme color you want to change, select the button next to that color, and then select a color under Theme Colors. To add your own color, select More Colors, and then select a color …

On the Page Layout tab in Excel or the Design tab in Word, click Colors, and then click Customize Colors. Click the button next to the theme color you want to change (for example, Accent 1 or …

To change color schemes, switch to a different theme. In Excel, click Page Layout, click the Colors button, and then pick the color scheme you want or create your own theme colors.

By default, gridlines are displayed in worksheets using the color that is assigned to Automatic. To change the color of gridlines, you can use the following procedure. Select the worksheets for …