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 …

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

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.

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 …

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 …

Adding a color to alternate rows or columns (often called color banding) can make the data in your worksheet easier to scan. To format alternate rows or columns, you can quickly apply a preset …

For example, add an underline to color-coded hyperlink text so that people who are colorblind know that the text is linked even if they can't see the color. For headings, consider adding bold …

To customize the line style or color of cell borders or erase existing borders, you can use the Draw Borders options. To draw cell borders, you'll first select the border type, then the border …

Learn how to add a legend to a chart, retrieve a missing legend, and adjust its settings. Add, edit, or remove a chart legend in Excel.

To use a fill color that is not available under Theme Colors or Standard Colors, click More Fill Colors. In the Colors dialog box, use the available options to create a custom fill color, and …