The only method that worked for me was the following:

Desktop/Properties/Appearance/Choosing Windows Classic or Windows Standard
for "Color Scheme"/Normal for "Font Size"/Apply/OK

I hope this helps...

"Gord Dibben" wrote:

If all workbooks and worksheets, perhaps this fix...............

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

On Sat, 7 Jul 2007 15:32:04 -0700, cindyhosch
wrote:

I can only see blk/white on my worksheets. I can change text color and/or
highlight a cell and it appears as though nothing happened. But - when I
pull up the 'preview' ... the colors show and the colors print correctly.

I want to use the highlight to mark cells that will be variable information
each time I use the template, so I need to be able to see the colors when the
worksheet is in 'active mode'. (hope that makes sense)

I did something that caused this problem... wasn't always like this.

Using Office XP

Thanks!