worksheet formating

S

stewbhoy

I wonder if someone could help with the problem i'm having with
applying colour formats to my spreadsheet? Whenever i try to add a
colour to the cell or the font it just wont do it, nor when i try
conditional formats. I am totally bemused by this one as i cant seem to
find any helpful hints within excel. i'm using excel 2003

thanks in advance
stuart
 
D

Dallman Ross

stewbhoy said:
I wonder if someone could help with the problem i'm having with
applying colour formats to my spreadsheet? Whenever i try to add
a colour to the cell or the font it just wont do it, nor when i
try conditional formats. I am totally bemused by this one as i
cant seem to find any helpful hints within excel. i'm using excel
2003
Click to expand...

If you have conditional formatting enabled, it will override
normal formatting when your condition is true.

-dman-
 
S

stewbhoy

Dallman said:
If you have conditional formatting enabled, it will override
normal formatting when your condition is true.

-dman-
Click to expand...

Thanks for your reply dman,

the problem i'm having is not just with conditional formats but adding
colour in any way to the cell or font even in a new blank worksheet,
although when i set a condional format to a cell and the criteria is
true, the font will change to bold but not the colour specified.

stuart
 
D

Dallman Ross

In <[email protected]>,
stewbhoy said:
Thanks for your reply dman,

the problem i'm having is not just with conditional formats but
adding colour in any way to the cell or font even in a new blank
worksheet, although when i set a condional format to a cell and
the criteria is true, the font will change to bold but not the
colour specified.
Click to expand...

Stuart, I'm out of ideas, sorry. Maybe someone else will think of
something.
 
G

Gord Dibben

Stuart

Might be this problem........................

The Windows High Contrast setting.

Read this KB article.

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


Gord Dibben MS Excel MVP


I wonder if someone could help with the problem i'm having with
applying colour formats to my spreadsheet? Whenever i try to add a
colour to the cell or the font it just wont do it, nor when i try
conditional formats. I am totally bemused by this one as i cant seem to
find any helpful hints within excel. i'm using excel 2003

thanks in advance
stuart
Click to expand...

Gord Dibben MS Excel MVP
 
Top