ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   colour fonts revert to black when pressing "Enter" (https://www.excelbanter.com/excel-discussion-misc-queries/73207-colour-fonts-revert-black-when-pressing-enter.html)

BAB

colour fonts revert to black when pressing "Enter"
 
My worksheets won't allow me to use colour fonts. I can write in colour while
in a cell, but the cell contents revert to black when I press "Enter" or
"Tab" and leave the cell. I've never come across this problem before. I
have tried to repair the Office 2003 installation, but it has not solved the
problem.

Kevin B

colour fonts revert to black when pressing "Enter"
 
If you're talking about the text colors when you are writing formulas, that
is an Excel typing aid that just helps to keep track of where you are when
writing nested formulas. It's a great help in keeping track of closed
parenthesis as it matches the color of the formula text it is closing. How
ever, this is just a visual aid and does not modify the color of the text
when you enter it into a cell.

To change the color of a font, from the menu clickFORMAT and select CELLS.
Click the FONT tab in the formatting dialog box and select the color of the
font from the COLOR combo box located roughly about mid-point on the dialog
page.
--
Kevin Backmann


"BAB" wrote:

My worksheets won't allow me to use colour fonts. I can write in colour while
in a cell, but the cell contents revert to black when I press "Enter" or
"Tab" and leave the cell. I've never come across this problem before. I
have tried to repair the Office 2003 installation, but it has not solved the
problem.


BAB

colour fonts revert to black when pressing "Enter"
 
Thanks Kevin, but I'm not talking about colours when writing formulas and I
also know how to change font colours using the Format command. It's just
that the colour selected won't remain when I leave the cell. Any further
thoughts?

"Kevin B" wrote:

If you're talking about the text colors when you are writing formulas, that
is an Excel typing aid that just helps to keep track of where you are when
writing nested formulas. It's a great help in keeping track of closed
parenthesis as it matches the color of the formula text it is closing. How
ever, this is just a visual aid and does not modify the color of the text
when you enter it into a cell.

To change the color of a font, from the menu clickFORMAT and select CELLS.
Click the FONT tab in the formatting dialog box and select the color of the
font from the COLOR combo box located roughly about mid-point on the dialog
page.
--
Kevin Backmann


"BAB" wrote:

My worksheets won't allow me to use colour fonts. I can write in colour while
in a cell, but the cell contents revert to black when I press "Enter" or
"Tab" and leave the cell. I've never come across this problem before. I
have tried to repair the Office 2003 installation, but it has not solved the
problem.


Debra Dalgleish

colour fonts revert to black when pressing "Enter"
 
If the high contrast setting is turned on you won't see the font colour.
There's information in the following MSKB article:

Changes to the fill color and the fill pattern are not displayed in
Office programs
http://support.microsoft.com/?id=320531


BAB wrote:
My worksheets won't allow me to use colour fonts. I can write in colour while
in a cell, but the cell contents revert to black when I press "Enter" or
"Tab" and leave the cell. I've never come across this problem before. I
have tried to repair the Office 2003 installation, but it has not solved the
problem.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


BAB

colour fonts revert to black when pressing "Enter"
 
Brilliant! That was the problem. Many thanks!

"Debra Dalgleish" wrote:

If the high contrast setting is turned on you won't see the font colour.
There's information in the following MSKB article:

Changes to the fill color and the fill pattern are not displayed in
Office programs
http://support.microsoft.com/?id=320531


BAB wrote:
My worksheets won't allow me to use colour fonts. I can write in colour while
in a cell, but the cell contents revert to black when I press "Enter" or
"Tab" and leave the cell. I've never come across this problem before. I
have tried to repair the Office 2003 installation, but it has not solved the
problem.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



Debra Dalgleish

colour fonts revert to black when pressing "Enter"
 
You're welcome! Thanks for letting me know that was the problem.

BAB wrote:
Brilliant! That was the problem. Many thanks!

"Debra Dalgleish" wrote:


If the high contrast setting is turned on you won't see the font colour.
There's information in the following MSKB article:

Changes to the fill color and the fill pattern are not displayed in
Office programs
http://support.microsoft.com/?id=320531


BAB wrote:

My worksheets won't allow me to use colour fonts. I can write in colour while
in a cell, but the cell contents revert to black when I press "Enter" or
"Tab" and leave the cell. I've never come across this problem before. I
have tried to repair the Office 2003 installation, but it has not solved the
problem.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 10:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com