Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
Palette problem
The palette of available colours are different between spreadsheets.
It would be reasonable to expect any two spreadsheets on the same computer using the same software (Excel 2003) which is installed only once to have the same palette of colours available on all spread sheets. This is a problem because I use certain colour combinations of background (fill colour) and font colour to identify certain conditions. However, in some instances these are not always available. Any idea why this is happening and how to get around the problem please. Thanks. Bill R |
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
Palette problem
Color pallettes are stored with the workbook. If you have them both open,
then you can use Tools/Options/Color/Copy Colors From... then pick the other workbook - now the pallettes will be the same. "Bill R" wrote in message ... The palette of available colours are different between spreadsheets. It would be reasonable to expect any two spreadsheets on the same computer using the same software (Excel 2003) which is installed only once to have the same palette of colours available on all spread sheets. This is a problem because I use certain colour combinations of background (fill colour) and font colour to identify certain conditions. However, in some instances these are not always available. Any idea why this is happening and how to get around the problem please. Thanks. Bill R |
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
Palette problem
"Bob Umlas" wrote in message
... Color pallettes are stored with the workbook. If you have them both open, then you can use Tools/Options/Color/Copy Colors From... then pick the other workbook - now the pallettes will be the same. "Bill R" wrote in message ... The palette of available colours are different between spreadsheets. It would be reasonable to expect any two spreadsheets on the same computer using the same software (Excel 2003) which is installed only once to have the same palette of colours available on all spread sheets. This is a problem because I use certain colour combinations of background (fill colour) and font colour to identify certain conditions. However, in some instances these are not always available. Any idea why this is happening and how to get around the problem please. Thanks. Bill R Thanks bob. Given that only one instance of Excel has ever been installed and I know I havn't changed the colour pallette it should not, logically, have changed. Have you any idea how the colour pallette option has become changed? Thanks. Bill R |
#4
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
Palette problem
"Bill R" wrote in message
... "Bob Umlas" wrote in message ... Color pallettes are stored with the workbook. If you have them both open, then you can use Tools/Options/Color/Copy Colors From... then pick the other workbook - now the pallettes will be the same. "Bill R" wrote in message ... The palette of available colours are different between spreadsheets. It would be reasonable to expect any two spreadsheets on the same computer using the same software (Excel 2003) which is installed only once to have the same palette of colours available on all spread sheets. This is a problem because I use certain colour combinations of background (fill colour) and font colour to identify certain conditions. However, in some instances these are not always available. Any idea why this is happening and how to get around the problem please. Thanks. Bill R Thanks bob. Given that only one instance of Excel has ever been installed and I know I havn't changed the colour pallette it should not, logically, have changed. Have you any idea how the colour pallette option has become changed? Thanks. Bill R Bob, Your answer was spot on! Now I know how to change the pallette I have checked all my spreadsheets. All the spreadsheets needing to be changed were first generated some years ago and it is now apparent that the differing pallettes was not due to an Excel configuration issue but rather because the older spreadsheetshee were generated by an older version of Excel. It's so obvious now I have the key. Bill R |
#5
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
Date display problem (was Palette problem)
Bob Umlas very kindly gave me the answer to a problem I have had for quite
some time with inconsistencies of palettes over various spreadsheets. I wonder if Bob or anyone else could help with another longstanding problem. When I choose a graph (any graph) and change the range (scale) of months (mmm yyyy) at the bottom of the graph, all dates in all spreadsheets which are open at the time or are subsequently opened are changed to be displayed as dd/mm/yy. This can be overcome by saving all spreadsheets, closing and then re-opening Excel which is something which, logically, should not happen. How can this be prevented please? Thanks. Bill R |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 - Color Palette problem. | Excel Discussion (Misc queries) | |||
Color Palette | Excel Discussion (Misc queries) | |||
Color Palette | Excel Discussion (Misc queries) | |||
Colour Palette Problem | Excel Discussion (Misc queries) | |||
Colour Palette Problem | Excel Discussion (Misc queries) |