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?

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 W@discussions.microsoft.com> wrote in message
news:2144CF14-9EA5-4461-9CA7-E4BBF443412C@microsoft.com...
> 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?
>

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

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
>
>

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 W@discussions.microsoft.com> wrote in message
> news:2144CF14-9EA5-4461-9CA7-E4BBF443412C@microsoft.com...
> > 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?
> >
>
>
>