shading problems

Guest · May 16, 2005

unable to change cell shading color in excel. can change font color,size,
etc.., but when trying to change shading it seems to "ignor" whatever color
is chosen. Thought maybe the cells were protected but happens on blank
worksheets also. any ideas?

Don Guillett · May 16, 2005

this might help??
http://support.microsoft.com/?id=320531

Gord Dibben · May 16, 2005

Can you see the shading when in Print Preview?

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

Shading Rows With IF Statements?	5	Oct 9, 2008
Formatting of cells in a locked worksheet. EG shading	1	Oct 20, 2008
Conditional Cell Shading (based on the shading of other cells)	2	May 10, 2005
how do I count the number of gray-shaded cells within a range?	4	Aug 10, 2006
conditionally formatting	3	Feb 28, 2010
custom color for font color and or background shading color	2	May 4, 2010
Shading a cell relative to three other cells & repeat	3	Aug 31, 2007
Excel 2007: cell shading (not conditional formatting)	1	Jan 6, 2010

shading problems

Guest

Don Guillett

Gord Dibben

Ask a Question

Similar Threads