Cells don't display color - Anyone know why?

[Ryan Miller]

Hi,

I have a user who is not able to see the color formatting of the cells
unless he shows the worksheet in print preview mode. For example, he'll
select a range of cells and will color them yellow. Nothing appears to
change, however, if he does a print preview, he can see the yellow cells.
Additionally, when the worksheet is sent to other users, they are able to
see the color.

Does anyone know what the problem may be? Is there a setting in the options
that may be set incorrectly in his Excel?

Thanks for your help,

Ryan

 

[Bob Phillips]

Ryan,

Does this article throw any light

http://support.microsoft.com/d­efault.aspx?kbid=320531
Changes to fill color and fill pattern are not displayed in Office programs

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Andi B]

It might be worth checking if the user is in page break view as opposed to
normal view. I don't know whether this will prevent coloured cells from
showing correctly, but its the only thing I can think of that might, other
than some OS based graphics settings.

 

[Guest]

Hi Ryan,
I had that problem before. Try this: Go to Control Panel, click on
Accessibility Options, click on Display tab, then you should uncheck the Use
High Contrast box, click OK to get out. See this will help. Good luck!