In a cell, select the data that you want to display in a different color or format.ĭouble-click the cell, and then drag across the contents of the cell that you want to select.Ĭlick the cell, and then drag across the contents of the cell that you want to select in the formula bar. When you're done, click Format Painter again or press ESC to turn it off.ĭisplay specific data in a different font color or format On the Home tab, in the Clipboard group, double-click Format Painter, and then drag the mouse pointer across as many cells or ranges of cells that you want to highlight. Select a cell that is formatted with the highlight that you want to use. Use Format Painter to apply a highlight to other cells If you see the cell styles box in the Styles group, and the new cell style is one of the first six cell styles on the list, you can click that cell style directly in the Styles group.
Note: Custom cell styles are displayed at the top of the list of cell styles.