Changing font colour in some cells
 

Hi
I am quite new to Excel!
I can change the appearance of text using bold, italic and underline but am
having problems with colour. When I select an active cell and click on a
colour nothing seems to happen. If I go back to the cell and double click it
shows the text in the colour I want but when I move to another cell it
reverts to black. Can anyone help please?

Changing font colour in some cells
 

Does this happen with all workbooks or just one? If the latter, maybe there
is some event code behind the sheet. On the tab name, right-click and
select View Code from the menu, if you see some code delete it.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Di W" <Di wrote in message
...
Hi
I am quite new to Excel!
I can change the appearance of text using bold, italic and underline but
am
having problems with colour. When I select an active cell and click on a
colour nothing seems to happen. If I go back to the cell and double click
it
shows the text in the colour I want but when I move to another cell it
reverts to black. Can anyone help please?

Changing font colour in some cells
 

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


Di W wrote:
Hi
I am quite new to Excel!
I can change the appearance of text using bold, italic and underline but am
having problems with colour. When I select an active cell and click on a
colour nothing seems to happen. If I go back to the cell and double click it
shows the text in the colour I want but when I move to another cell it
reverts to black. Can anyone help please?



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

Changing font colour in some cells
 

Many thanks. Problem solved!

Di W

"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


Di W wrote:
Hi
I am quite new to Excel!
I can change the appearance of text using bold, italic and underline but am
having problems with colour. When I select an active cell and click on a
colour nothing seems to happen. If I go back to the cell and double click it
shows the text in the colour I want but when I move to another cell it
reverts to black. Can anyone help please?



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

Changing font colour in some cells
 

Bob

The problem was to do with the high contrast setting, but thanks for your
suggestion.
Di W

"Bob Phillips" wrote:

Does this happen with all workbooks or just one? If the latter, maybe there
is some event code behind the sheet. On the tab name, right-click and
select View Code from the menu, if you see some code delete it.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Di W" <Di wrote in message
...
Hi
I am quite new to Excel!
I can change the appearance of text using bold, italic and underline but
am
having problems with colour. When I select an active cell and click on a
colour nothing seems to happen. If I go back to the cell and double click
it
shows the text in the colour I want but when I move to another cell it
reverts to black. Can anyone help please?