Why did my fonts change color automatically?

[tech]

Hi,

I was wondering does anyone know what can cause the fonts
in my excel worksheet to change colors automatically?

I originally had my font color to be black after I saved
and exited the excel file and now that I opened my excel
file again, most of the fonts in the my worksheets changed
from black to blue font color.

I know for sure that nobody went into my file and changed
those colors themselves.

Has anyone ever encountered this problem and do you know
the reason why the font colors changed?

Thanks in advance.

 

[Gord Dibben]

tech

Just "most" and not "all" of the fonts changed color?

All worksheets or just some?

Just one file or many/all files?

Format>Style can be modified to change the font colors.

Windows Desktop Appearance settings could have been changed.

You may have inadvertantly set Conditional Formatting on "most" cells.

Have never seen this happen without some sort of user assistance.

Gord Dibben Excel MVP

 

[Guest]

gord,

most of the text in my worksheets turned blue, not all of
them.

also, all the worksheets in that one file was affected,
therefore, most of the text in each worksheet were blue.

and it only happened in one excel file.

thanks for your help.

 

[Gord Dibben]

tech

Is the blue text on each sheet in the same area(s)/range(s)?

Possible you had/have sheets grouped and made font color changes on one of the
grouped sheets, which would affect all sheets.

Do you see [Group] after the filename in the Title Bar at top left?

If so, with the sheets grouped, select the cells with the blue font and change
to black.

Ungroup sheets by right-clicking on one and "ungroup sheets".

Gord Dibben Excel MVP

 

[Guest]

gord,

the blue text aren't in the same area(s)/range, instead
they are all scattered throught the worksheets.

also, the worksheets weren't grouped and there is no
[Group] after the filename in the Title Bar at top left.

The problem happened again to another file, could it be
that the file was originally saved on excel 2000 and then
saved again on a computer running excel 2003? Could that
have caused it?

Thanks.

-----Original Message-----
tech

Is the blue text on each sheet in the same area(s)/range (s)?

Possible you had/have sheets grouped and made font color changes on one of the
grouped sheets, which would affect all sheets.

Do you see [Group] after the filename in the Title Bar at top left?

If so, with the sheets grouped, select the cells with the blue font and change
to black.

Ungroup sheets by right-clicking on one and "ungroup sheets".

Gord Dibben Excel MVP

gord,

most of the text in my worksheets turned blue, not all of
them.

also, all the worksheets in that one file was affected,
therefore, most of the text in each worksheet were blue.

and it only happened in one excel file.

thanks for your help.

.

 

[Gord Dibben]

anon

I have 3 versions of Excel on my computer.

97, 2002, and 2003.

I open files in any version and cannot replicate your problem without user
intervention.

You could send me the file and I will have a look for "whatever".

Change the AT and the DOT to get my email address.

Gord

gord,

the blue text aren't in the same area(s)/range, instead
they are all scattered throught the worksheets.

also, the worksheets weren't grouped and there is no
[Group] after the filename in the Title Bar at top left.

The problem happened again to another file, could it be
that the file was originally saved on excel 2000 and then
saved again on a computer running excel 2003? Could that
have caused it?

Thanks.

-----Original Message-----
tech

Is the blue text on each sheet in the same area(s)/range (s)?

Possible you had/have sheets grouped and made font color changes on one of the
grouped sheets, which would affect all sheets.

Do you see [Group] after the filename in the Title Bar at top left?

If so, with the sheets grouped, select the cells with the blue font and change
to black.

Ungroup sheets by right-clicking on one and "ungroup sheets".

Gord Dibben Excel MVP

gord,

most of the text in my worksheets turned blue, not all of
them.

also, all the worksheets in that one file was affected,
therefore, most of the text in each worksheet were blue.

and it only happened in one excel file.

thanks for your help.

-----Original Message-----
tech

Just "most" and not "all" of the fonts changed color?

All worksheets or just some?

Just one file or many/all files?

Format>Style can be modified to change the font colors.

Windows Desktop Appearance settings could have been
changed.

You may have inadvertantly set Conditional Formatting
on "most" cells.

Have never seen this happen without some sort of user
assistance.

Gord Dibben Excel MVP

On Tue, 6 Jul 2004 14:31:32 -0700, "tech"

Hi,

I was wondering does anyone know what can cause the
fonts
in my excel worksheet to change colors automatically?

I originally had my font color to be black after I saved
and exited the excel file and now that I opened my excel
file again, most of the fonts in the my worksheets
changed
from black to blue font color.

I know for sure that nobody went into my file and
changed
those colors themselves.

Has anyone ever encountered this problem and do you know
the reason why the font colors changed?

Thanks in advance.

.

.