Question Locked

Excel 2003 - Font Color reverts to black in color when moving to a new cell

0 helpful
13 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

When I change the font color of text to red or any color, and move over to another cell, the color automatically changes back to black in color. I have already repaired and reinstalled MS-Office, but it continues to change colors. Any help will be appreciated.

Thanks,
Randy

13 replies

by captbilly1eye

Please forgive what may be a stupid question, but the issue description was unclear...

When you say that 'the font color changes back to black when you click another cell,' was the next cell that you click in previously formated for a the different font color?

So, in other words, you highlight a column or row, change the font color to red with that row or column still highlighted and then later click within that previously formated column or row and the font changes back to black?

The reason I ask this is because the normal behavior of the cells in an Excel spreadsheet is to default to the system's default font style and color (black) unless the cells properties are previously changed.

You can select individual cells for formatting by using the CTRL+click combo and you can format all the cells in an entire spreadsheet by clicking in the very upper right hand corner box to highlight the whole sheet.

by randy.black

Correct - when I select the text in one cell and change the color to RED, and then tab over to the next cell, the red colors change back to black. I will check the default settings as you suggested. Thanks for your reply.

Randy

by captbilly1eye

Excel is behaving exactly as designed.

If you "select the text in one cell and change the color to red, and then tab over to the next cell," then the font SHOULD change back to black. Because you have not formatted that cell to have the font color change.

Font color changes only apply to the text in the cell that is selected.

[b]To have a font color change apply to more than one cell[/b], you have to FIRST select the cells by highlighting them BEFORE typing any text, and THEN select the font color in the top tool bar. After that, any text you type into those particular cells will have the different color.

In addition, you can change the text already typed into existing cells by highlighting all the cells and then making the color or style change in the top tool bar.

by randy.black

Let me be more specific in my description.

I change the Text color in Cell A1 to RED and when I TAB to Cell B1 ----> The color in A1 changes back to BLACK. So after formatting the font / text color in a cell, the minute I move the cursor to another cell (any cell) the font changes back to BLACK.

Thanks for your help here. Randy

by captbilly1eye

Is this occurring in all spreadsheets?
If in only one, is this a spreadsheet that you created from scratch?
If you did not create the spreadsheet, is it a 'protected' spreadsheet?

by randy.black

New - spreadsheet, nothing special, no advanced macro's or filtering or encryption. Just a plain ole new spreadsheet when you open Excel. I have found it does not matter what spreadsheet you open, it happens. Thanks Capt.

TOP (Retired 1SG)

by captbilly1eye

It is not a protected spreadsheet.
You have uninstalled and reinstalled.

I'm assuming you tried a clean-install where Office was uninstalled through Add/Remove and then the Office folders where deleted from Program Files with reboots in-between before re-installing.
I'm also assuming you performed all the Office updates after re-installing.

Other than trying a new spreadsheet, saving it to the desktop, closing Excel, right-clicking on the new spreadsheet on the desktop and making sure it isn't set to Read-Only, reopening that spreadsheet in Excel and trying then...

I'm at a loss.
Sorry I couldn't be of more help.

by captbilly1eye

Were you ever able to resolve the issue?
If so, what ultimately fixed it?

by gary56789

Excel should do what you want if you select all the cells that you will be using for the different font color first, then select the color of font.

All selected cells will then have the font color you desire as you are entering data, while the cells you didn't select will revert to the default black font.

Under the Tools--Options--General tab, you can change the default font size and type, but not the default color for the whole document. Thus, the above instructions.

by captbilly1eye

You have to read the later posts.
There IS (or was) an issue.
It is not a How-To thing.

by kk7

Hello all,
Thank you all for your time and information.
I have a client with the EXACT same issue.
It used to work fine, then started defaulting to black whenever she pressed Enter, Tab, or clicked on a new cell.
She can take the document to another computer, and the font color she selected is shown on that computer.
She can also copy a section of the spreadsheet that has both default font color and user selected font color, paste it into a Word document, and the color displays on the screen correctly. It's only in Excel that the color does not display.
She believes she may have changed something in Excel that caused this. I have yet to find that setting, if there is one.
She was using Office 2003, and has since upgraded to 2007. She has not fully uninstalled and reinstalled it yet.
I feel like it is a setting/option within Excel, I just need to find out which one.
Thank you for your help.

This discussion is closed to new replies.