Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Di W
 
Posts: n/a
Default 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?

  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bob Phillips
 
Posts: n/a
Default 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?



  #3   Report Post  
Posted to microsoft.public.excel.newusers
Debra Dalgleish
 
Posts: n/a
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.newusers
Di W
 
Posts: n/a
Default 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


  #5   Report Post  
Posted to microsoft.public.excel.newusers
Di W
 
Posts: n/a
Default 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?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
font colour won't change in Excel 2003 BAB Excel Discussion (Misc queries) 1 February 10th 06 02:56 PM
How do I set a colour to 4 cells based on the value of a cell Andy64 Excel Discussion (Misc queries) 1 September 6th 05 06:46 PM
Change Font colour mid-worksheet: Excel 2003 John L Excel Discussion (Misc queries) 2 July 12th 05 12:58 PM
i want to use the =if function to apply a colour to other cells pookie1970 Excel Worksheet Functions 1 June 20th 05 05:53 PM
Conditional format if cell=0 then font colour same as background . Paligap Excel Discussion (Misc queries) 2 December 20th 04 12:07 AM


All times are GMT +1. The time now is 02:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"