Changing Font Color

by Allen Wyatt
(last updated July 27, 2013)

2

Normally, Excel displays information using black type. This is acceptable if you are printing to a regular printer, but many people these days have color printers. Additionally, you may want to simply use different colors for displaying information on the screen. You can change the font color used by Excel in the following manner:

  1. Choose the cells whose font color you wish to change.
  2. Choose Cells from the Format menu. Excel displays the Format Cells dialog box.
  3. Make sure the Font tab is selected. (See Figure 1.)
  4. Figure 1. The Font tab of the Format Cells dialog box.

  5. Using the Color drop-down list, select the color you want used for the information in the cells you selected in step 1.
  6. Click on OK.

There is another way to change font color, and you might find it a bit faster. You can change font color using the toolbars in this manner.

  1. Choose the cells whose font color you wish to change.
  2. Click on the down-arrow at the right side of the Font Color tool on the toolbar. This displays a color palette.
  3. Click on the color you wish to use.

At this point the color of the information in the selected cell is changed. You may also have noticed that the color bar at the bottom of the Font Color tool changed, as well. This means that in the future, all you need to do is select cells and click on the tool to change their font to the same color.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2674) applies to Microsoft Excel 97, 2000, 2002, and 2003.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Random OLE Bookmarks

Word has an irritating habit of placing unwanted bookmarks in a document that you've been editing for a while. These ...

Discover More

Jumping Around Folders

When you open a workbook in Excel, the Open dialog box always starts within the folder in which you were last working. You ...

Discover More

Changing the Lock Screen's Background Picture

Don't like the picture you first see when you look at your computer? Windows makes it easy to change the Lock Screen picture ...

Discover More

Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!

More ExcelTips (menu)

Hiding Rows Based on a Cell Value

This tip contains a macro to hide rows that contain data you don't want to see.

Discover More

Hiding Columns Based on a Cell Value

Need to hide a given column based on the value in a particular cell? The easiest way to accomplish the task is to use a ...

Discover More

Sorting ZIP Codes

Sorting ZIP Codes can be painless, provided all the codes are formatted the same. Here's how to do the sorting if you have ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is six less than 6?

2015-02-24 07:35:41

Eva

Yes, it is. In the edit mode you choose the text portion to colour and use the right-click to access the colouring options (one of several ways). It seems though that there is a kind of cell formatting that prevents this colouring - or any other format, for that matter - to be shown once you leave the cell.
I had to copy formatting from a cell which showed my chosen colours and apply it to the rest and all started working.


2015-01-13 13:10:24

amanda

is it possible to change only SOME of the copy in a cell? I want to have 2 different colors within the same cell. It seems that even if i select the copy i want to change, the change affects the whole cell.


This Site

Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.