Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cell colors in Excel 2003
One of our senior managers has used various colors to signify various levels
of importance to items in the cells of a worksheet in Excel 2003. This morning he opened the file, and found that the colors had changed, for example yellow is now grey, blue is orange, etc. Can anyone help me understand what has happened and how to correct this, without the necessity of reformatting hundreds of cells. Thanks Paul |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cell colors in Excel 2003
Possible answers:
If he used conditional formats (which he should) the conditions have changed. Someone (unidentifed) has changed the colors The colors associated with the workbook structure have changed. By this I mean, if you go to Tools-Options-Colors, and were to change the default "yellow" to a "gray" all the cells that were previouslly yellow would now look grey. This is because XL actually assigns the cells a format number (1-56) to correspond with the 56 colors that is has stored (ie, a library). If the library is changed, the reference number becomes confused. To fix this, simply change the colors back to what you would like it to be (from the Options dialogue). -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "PA" wrote: One of our senior managers has used various colors to signify various levels of importance to items in the cells of a worksheet in Excel 2003. This morning he opened the file, and found that the colors had changed, for example yellow is now grey, blue is orange, etc. Can anyone help me understand what has happened and how to correct this, without the necessity of reformatting hundreds of cells. Thanks Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 colors do not match excel 2003 colors. | Excel Discussion (Misc queries) | |||
Excel 2003 Formula cell reference colours (colors) | Setting up and Configuration of Excel | |||
MY 2003 Excel does not show cell colors. Solution? Setting? | Excel Discussion (Misc queries) | |||
Dont display the colors on the Cell ( Excel 2003 ) | New Users to Excel | |||
Colors with EXCEL 2003 | Excel Discussion (Misc queries) |