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.

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

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

The following list describes the text values that the CELL function returns when the Info_type argument is "format" and the reference argument is a cell that is formatted with a built-in …

When you select a single cell, the cell is highlighted with a colored border. When you select a range of cells, the range is highlighted with a colored border and all cells except the active cell …

Highlight alternate rows or columns of data with colors or patterns to improve the readability of your Excel worksheets.

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 …

Change the text color for a cell or range of cells Select the cell or range of cells that has the data you want to format. You can also select just a portion of the text within a cell. On the Home …