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

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

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

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

You can use conditional formatting to highlight cells that contain values that meet a certain condition, or format a whole cell range and vary the exact format as the value of each cell varies.

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 Shading menu.

Conditional formatting makes it easy to highlight certain values or make particular cells easy to identify. This changes the appearance of a cell range based on a condition (or criteria).

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

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 number format.