Changing Data Color

Changing Data Color

You can change the color of the numbers and text on a worksheet. Strategic use of font color can be an effective way of tying similar values together. For instance, on a sales worksheet you might want to display sales in green and returns in red. Or, you may want to highlight column or row headers with colored labels. Either way, using color to highlight numbers and texts makes deciphering your worksheet data easier.

Change Font Color Using the Formatting Toolbar

Select a cell or range that contains the text you want to change.

Click the Font Color button list arrow on the Formatting toolbar.

Click a color.

Did You Know?

The Font Color button on the Formatting toolbar displays the last font color you used . To apply this color to another selection, simply click the button, not the list arrow.