Worksheet formatting (fill colors & text colors) disappeared

[sweettooth]

Excel 2003: This particular workbook has informatin from 2002 to current.
All sheets have always had colored text and fill colors. All of a sudden
that formatting disappeared on all of the sheets. Need to get the colors
back. I tried changing the font color and re-adding fill color, but the
formatting still does not show. Have no idea what I could have possibly done
to make the formatting go away. Even on new worksheets or workbooks, the
font colors and fill colors do not show. Thanking you in advance for your
assistance.

 

[Dave]

Hi,
Just throwing ideas around:
What happens when you open the file on another computer, on a different XL
installation?
Try Tools > Options > Color tab, Reset.
Regards - Dave.

 

[Gord Dibben]

Have you recently made any changes to Windows Accessiblity options?

Check this out................

http://support.microsoft.com/default.aspx?kbid=833258

The fill color, the fill pattern, or the line color of a WordArt or
AutoShape object in an Office document does not change

As directed, change the High Contrast setting in Windows OS


Gord Dibben MS Excel MVP