Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Fill colors and high contrast

Vista SP1. Excel 2007 (Excel 2003 compatibility mode). I juts (painfully)
discovered that if you use High Contrast the fill colors will not show in
one's Excel workbooks. It would be nice to have a warning! Any way to
resolve the issue?
Thanks

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 857
Default Fill colors and high contrast

Hi Philippeam,

I am not clear on what you mean by "High Contrast", however, if you are
applying colors form the 2007 color palette to a Excel 2003 file you will
loose the new capabilities when you are in 2003. Very simply put Excel 2003
supports 56 colors in the spreadsheet at one time while 2007 support 16
Million (I've heard different numbers on this.) When you apply colors from
Excel 2007 palette and save the file as a 2003 file Excel must convert the
colors to the 56 color palette, so there is a great lose of capability.

I get a warning when I save the 2003 file from within 2007. To turn this
option on choose Office Button, Prepare, Run Compatibility Checker, and
chick the box at the bottom left that says Check compatibility when saving
this workbook.

Cheers,
Shane Devenshire
Microsoft Excel MVP

"Philippeam" wrote in message
...
Vista SP1. Excel 2007 (Excel 2003 compatibility mode). I juts
(painfully)
discovered that if you use High Contrast the fill colors will not show in
one's Excel workbooks. It would be nice to have a warning! Any way to
resolve the issue?
Thanks

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Fill colors and high contrast

Thanks for your answer. The high contrast is an option offered in the "ease
of access" options. I am not sure it is the same as the different palettes in
Excel 2007 versus 2003 but may be it is.

"Shane Devenshire" wrote:

Hi Philippeam,

I am not clear on what you mean by "High Contrast", however, if you are
applying colors form the 2007 color palette to a Excel 2003 file you will
loose the new capabilities when you are in 2003. Very simply put Excel 2003
supports 56 colors in the spreadsheet at one time while 2007 support 16
Million (I've heard different numbers on this.) When you apply colors from
Excel 2007 palette and save the file as a 2003 file Excel must convert the
colors to the 56 color palette, so there is a great lose of capability.

I get a warning when I save the 2003 file from within 2007. To turn this
option on choose Office Button, Prepare, Run Compatibility Checker, and
chick the box at the bottom left that says Check compatibility when saving
this workbook.

Cheers,
Shane Devenshire
Microsoft Excel MVP

"Philippeam" wrote in message
...
Vista SP1. Excel 2007 (Excel 2003 compatibility mode). I juts
(painfully)
discovered that if you use High Contrast the fill colors will not show in
one's Excel workbooks. It would be nice to have a warning! Any way to
resolve the issue?
Thanks


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Fill colors and high contrast

Going through the forum I found the answer; it is in KB833258. There does
not seem to be another solution than turning High Contrast off. And if there
is a warning that EXCEL fill colors will disappear if you chose the optio, it
is sure hard to find!

"Shane Devenshire" wrote:

Hi Philippeam,

I am not clear on what you mean by "High Contrast", however, if you are
applying colors form the 2007 color palette to a Excel 2003 file you will
loose the new capabilities when you are in 2003. Very simply put Excel 2003
supports 56 colors in the spreadsheet at one time while 2007 support 16
Million (I've heard different numbers on this.) When you apply colors from
Excel 2007 palette and save the file as a 2003 file Excel must convert the
colors to the 56 color palette, so there is a great lose of capability.

I get a warning when I save the 2003 file from within 2007. To turn this
option on choose Office Button, Prepare, Run Compatibility Checker, and
chick the box at the bottom left that says Check compatibility when saving
this workbook.

Cheers,
Shane Devenshire
Microsoft Excel MVP

"Philippeam" wrote in message
...
Vista SP1. Excel 2007 (Excel 2003 compatibility mode). I juts
(painfully)
discovered that if you use High Contrast the fill colors will not show in
one's Excel workbooks. It would be nice to have a warning! Any way to
resolve the issue?
Thanks


  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Fill colors and high contrast

This has been a problem for a while.

Started with Excel 2003

Check this out................

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 Tue, 6 May 2008 09:48:02 -0700, Philippeam
wrote:

Thanks for your answer. The high contrast is an option offered in the "ease
of access" options. I am not sure it is the same as the different palettes in
Excel 2007 versus 2003 but may be it is.

"Shane Devenshire" wrote:

Hi Philippeam,

I am not clear on what you mean by "High Contrast", however, if you are
applying colors form the 2007 color palette to a Excel 2003 file you will
loose the new capabilities when you are in 2003. Very simply put Excel 2003
supports 56 colors in the spreadsheet at one time while 2007 support 16
Million (I've heard different numbers on this.) When you apply colors from
Excel 2007 palette and save the file as a 2003 file Excel must convert the
colors to the 56 color palette, so there is a great lose of capability.

I get a warning when I save the 2003 file from within 2007. To turn this
option on choose Office Button, Prepare, Run Compatibility Checker, and
chick the box at the bottom left that says Check compatibility when saving
this workbook.

Cheers,
Shane Devenshire
Microsoft Excel MVP

"Philippeam" wrote in message
...
Vista SP1. Excel 2007 (Excel 2003 compatibility mode). I juts
(painfully)
discovered that if you use High Contrast the fill colors will not show in
one's Excel workbooks. It would be nice to have a warning! Any way to
resolve the issue?
Thanks



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can u color (fill in) cells in XL when using High Contrast featur TG Excel Discussion (Misc queries) 1 January 10th 08 04:28 AM
Highlight in Excel When I Use High Contrast Black Windows Color Sc montgomerymouse Excel Discussion (Misc queries) 2 March 7th 06 04:18 AM
Can't format font colors or cell fill-in colors canoeron Excel Discussion (Misc queries) 3 August 22nd 05 11:46 PM
FILL COLORS ELYOD NANOC Excel Worksheet Functions 1 March 6th 05 11:53 PM
Better Fill Colors? callmekilo Excel Discussion (Misc queries) 1 January 2nd 05 03:34 PM


All times are GMT +1. The time now is 07:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"