Problem formatting cells in Excel 2003 (the worksheet is not protected)

[Claire Daniell]

One of our customers is having problems with a document they use on Excel.
they cannot format the font colour or cell colour on any part of the
worksheet.

They go to format it, make their selection colour wise click ok, the
worksheet page appears again. But the cells are still blank in colour and
the font colour hasn't changed.

If you go to print preview it shows where changes have been made however the
customer does not print the worksheet off, she relies on the screen.

Remotely I have logged onto and opened up a blank excel document and exactly
the same thing happens. She has unlimited permission so there should be no
reason why she cannot format the worksheet.

Any ideas, please help!

 

[Gord Dibben]

Claire

If this is a problem with all Excel files with coloured cells, the Windows OS
high contrast setting may be turned on. There is information in the
following MSKB article:

OFF: Changes to Fill Color and Fill Pattern Are Not Displayed

http://support.microsoft.com/default.aspx?scid=kb;en-ca;320531


Gord Dibben Excel MVP

One of our customers is having problems with a document they use on Excel.
they cannot format the font colour or cell colour on any part of the
worksheet.

They go to format it, make their selection colour wise click ok, the
worksheet page appears again. But the cells are still blank in colour and
the font colour hasn't changed.

If you go to print preview it shows where changes have been made however the
customer does not print the worksheet off, she relies on the screen.

Remotely I have logged onto and opened up a blank excel document and exactly
the same thing happens. She has unlimited permission so there should be no
reason why she cannot format the worksheet.

Any ideas, please help!

Gord Dibben MS Excel MVP