ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Color Problems (https://www.excelbanter.com/excel-programming/364374-color-problems.html)

John Keith[_2_]

Color Problems
 
My shop has just gotten new PC's (all machines were created from the same
image) Office 2003 is loaded. One of my co-workers is have a very strange
problem with her excel. Any workbooks loaded on her PC are displayed on the
screen with out any color (text color or background). The same file when
loaded on my PC shows the colors properly. The appearance is as if the
entire worksheet had been selected and then the background color was set to
"no fill".

Things that have been checked:
1. Options|Colors|Reset colors; no change
2. Using the quick color assignment toolbar buttons (the proper color
selections appear with the button-drop-down, but clicking the button will not
assign any color)
3. The workbook and worksheet are UN-protected (changes are allowed- Bold
setting still works on the appearance of the data)
4. Page-Setup|sheet|Black and White is NOT checked and even if it is checked
the screen colors do not change untill you look at a print-preview.
5. Display Properties|Color is set to Highest(32-bit)
6. Screen Saver is one of the default WindowsXP settings.

What could cause this?
Before we un-install and re-install Office... does anyone have any ideas of
something else to try?

--
Regards,
John

keeena

Color Problems
 
When you say "without any color (text color or background)", I assume
you mean everything looks white? Is the text visible or no? Is there
a cell grid (the default light gray grid) or no?


John Keith[_2_]

Color Problems
 
Text is visible. All appears black and white. Grid lines are black (all of
the
borders are set to the solid black line). Still the oddest part of all this
is that when I try to set a background or text color, the button click does
nothing at all.

--
Regards,
John


"keeena" wrote:

When you say "without any color (text color or background)", I assume
you mean everything looks white? Is the text visible or no? Is there
a cell grid (the default light gray grid) or no?



keeena

Color Problems
 
AFAIK there is no Excel property that would cause this. Doesn't mean
there isn't one...I've just never heard of it.

Some other items which could affect formatting and may be worth
checking
Conditional Formatting
Embedded code / Add-ins

Sorry I couldn't help you more.


John Keith[_2_]

Color Problems
 
Thanks for the replies :)

Conditional formatting or embedded code would be saved with the workbook.
This would have caused the same issue on my PC but that was not the case.

The part that warrants further checking is any Add-in(s) installed (but my
thought is that there are not any, because this is a new install from an
image for the dapartment)

--
Regards,
John


"keeena" wrote:

AFAIK there is no Excel property that would cause this. Doesn't mean
there isn't one...I've just never heard of it.

Some other items which could affect formatting and may be worth
checking
Conditional Formatting
Embedded code / Add-ins

Sorry I couldn't help you more.



Peter T

Color Problems
 
Still the oddest part of all this
is that when I try to set a background or text color, the button click

does
nothing at all.


That sounds like the sheet is protected (formats only perhaps). You said it
wasn't in your OP but might be worth double checking.

Regards,
Peter T

"John Keith" wrote in message
...
Text is visible. All appears black and white. Grid lines are black (all

of
the
borders are set to the solid black line). Still the oddest part of all

this
is that when I try to set a background or text color, the button click

does
nothing at all.

--
Regards,
John


"keeena" wrote:

When you say "without any color (text color or background)", I assume
you mean everything looks white? Is the text visible or no? Is there
a cell grid (the default light gray grid) or no?





John Keith[_2_]

Color Problems
 
Both worksheet and workbook protection were off (when looking at the menu,
both of the choices were to "Protect"). Is there a seperate protection for
formatting-only somehere?

I'll double check on Monday, but I think they have already uninstalled and
re-installed Office.
--
Regards,
John


"Peter T" wrote:

Still the oddest part of all this
is that when I try to set a background or text color, the button click

does
nothing at all.


That sounds like the sheet is protected (formats only perhaps). You said it
wasn't in your OP but might be worth double checking.

Regards,
Peter T

"John Keith" wrote in message
...
Text is visible. All appears black and white. Grid lines are black (all

of
the
borders are set to the solid black line). Still the oddest part of all

this
is that when I try to set a background or text color, the button click

does
nothing at all.

--
Regards,
John


"keeena" wrote:

When you say "without any color (text color or background)", I assume
you mean everything looks white? Is the text visible or no? Is there
a cell grid (the default light gray grid) or no?






Peter T

Color Problems
 
In XL2002+ there is a drop down list of options, including formats, you can
include/exclude with protection.

Regards,
Peter T

"John Keith" wrote in message
...
Both worksheet and workbook protection were off (when looking at the menu,
both of the choices were to "Protect"). Is there a seperate protection

for
formatting-only somehere?

I'll double check on Monday, but I think they have already uninstalled and
re-installed Office.
--
Regards,
John


"Peter T" wrote:

Still the oddest part of all this
is that when I try to set a background or text color, the button click

does
nothing at all.


That sounds like the sheet is protected (formats only perhaps). You said

it
wasn't in your OP but might be worth double checking.

Regards,
Peter T

"John Keith" wrote in message
...
Text is visible. All appears black and white. Grid lines are black

(all
of
the
borders are set to the solid black line). Still the oddest part of

all
this
is that when I try to set a background or text color, the button click

does
nothing at all.

--
Regards,
John


"keeena" wrote:

When you say "without any color (text color or background)", I

assume
you mean everything looks white? Is the text visible or no? Is

there
a cell grid (the default light gray grid) or no?









All times are GMT +1. The time now is 09:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com