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 …

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 …

Make a table to shade or highlight alternate rows. The easiest way to apply shading or highlighting to alternate rows is to make them a table. Tables also include tools to help you analyze your data.

To use a pattern with two colors, select another color in the Pattern Color box, and then select a pattern style in the Pattern Style box. To use a pattern with special effects, select Fill Effects, …

• To alternate blue and white rows in your list for easy reading, select Alternating row styles. • To make other changes to alternate rows, such as different colors, fonts, and borders, select Edit …

To add special formatting to the last row in a table, select Design > Total Row. To alternate row or column colors and make tables easier to read, select Design > Banded Rows or Design > …

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 …

When you create a single-series chart, all data markers that represent the data points in that data series are displayed in the same color. To use different colors for each data marker, you can …

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

If you want more color options, click More Border Colors, and then either click the color that you want on the Standard tab, or mix your own color on the Custom tab. Custom colors and colors …