Here's how: Select the range of cells that you want to format. Go to Home > Format as Table. Pick a table style that has alternate row shading. To change the shading from rows to …

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 …

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 …

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, …

How to use conditional formatting in Excel to visually explore, analyze, and identify patterns and trends.

Adding shading to a table can help make certain rows, columns, or cells—or the entire table—stand out in your document. The easiest way to add colored shading to a table is to use …

Set varying colors of data markers (bars, columns, lines, pie or doughnut slices, dots, and other shapes) automatically in an Office chart.

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 …

Tip: Chart styles (combinations of formatting options and chart layouts) use the theme colors. To change color schemes, switch to a different theme. In Excel, click Page Layout, click the …

Click the arrow in the column that contains the content that you want to filter. Under Filter, in the By color pop-up menu, select Cell Color, Font Color, or Cell Icon, and then click the criteria.