Changing font colour in some cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Di W - 12 Mar 2006 12:27 GMT

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 to this Message

Bob Phillips - 12 Mar 2006 14:37 GMT

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.

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> Hi
> I am quite new to Excel!
[quoted text clipped - 3 lines]
> shows the text in the colour I want but when I move to another cell it
> reverts to black. Can anyone help please?

Reply to this Message

Di W - 12 Mar 2006 18:58 GMT

Bob

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

> 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
[quoted text clipped - 9 lines]
> > shows the text in the colour I want but when I move to another cell it
> > reverts to black. Can anyone help please?

Reply to this Message

Debra Dalgleish - 12 Mar 2006 16:48 GMT

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

> Hi
> I am quite new to Excel!
[quoted text clipped - 3 lines]
> shows the text in the colour I want but when I move to another cell it
> reverts to black. Can anyone help please?

Signature

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

Reply to this Message

Di W - 12 Mar 2006 18:58 GMT

Many thanks. Problem solved!

Di W

> If the high contrast setting is turned on you won't see the font colour.
> There's information in the following MSKB article:
[quoted text clipped - 10 lines]
> > shows the text in the colour I want but when I move to another cell it
> > reverts to black. Can anyone help please?

Reply to this Message