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

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

Image Click the Home tab.

Click ...

Get Excel® 2013 On Demand now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.