Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shade differences in excel file
I received an excel file that has a light grey shading. But when I
copy and paste the format to an excel file that I created, the shading comes out light yellow. I ran some code to tell me what the Interior.ColorIndex is and it returned 19 for both the grey cell and the light yellow cell. What's causing the difference? Is is simply a difference in excel versions? I am working from Excel 2003 (the person I received the file from is unavailable so I don't know what version they are using) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shade differences in excel file
try going to tools/options and on the color tab, click reset and see if that
helps -- Gary wrote in message ... I received an excel file that has a light grey shading. But when I copy and paste the format to an excel file that I created, the shading comes out light yellow. I ran some code to tell me what the Interior.ColorIndex is and it returned 19 for both the grey cell and the light yellow cell. What's causing the difference? Is is simply a difference in excel versions? I am working from Excel 2003 (the person I received the file from is unavailable so I don't know what version they are using) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shade differences in excel file
On Apr 10, 1:56*pm, "Gary Keramidas" <GKeramidasATmsn.com wrote:
try going to tools/options and on the color tab, click reset and see if that helps -- Gary wrote in message ... I received an excel file that has a light grey shading. *But when I copy and paste the format to an excel file that I created, the shading comes out light yellow. *I ran some code to tell me what the Interior.ColorIndex is and it returned 19 for both the grey cell and the light yellow cell. What's causing the difference? *Is is simply a difference in excel versions? *I am working from Excel 2003 (the person I received the file from is unavailable so I don't know what version they are using)- Hide quoted text - - Show quoted text - Hi, The source workbook has had the colour palette customised. This explains the different colours, but same colour index. If you want the pasted data to have the same colouring, the easiest way is probably to go 'Tools' - 'Options' - 'Colour' while the new workbook is active, and use the 'Copy colors from' option. (This is assuming Excel 2003 or lower, can't remember where the option has been moved to in 2007). Cheers, |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shade differences in excel file
On Apr 10, 1:19*am, Ivyleaf wrote:
On Apr 10, 1:56*pm, "Gary Keramidas" <GKeramidasATmsn.com wrote: try going to tools/options and on the color tab, click reset and see if that helps -- Gary wrote in message ... I received an excel file that has a light grey shading. *But when I copy and paste the format to an excel file that I created, the shading comes out light yellow. *I ran some code to tell me what the Interior.ColorIndex is and it returned 19 for both the grey cell and the light yellow cell. What's causing the difference? *Is is simply a difference in excel versions? *I am working from Excel 2003 (the person I received the file from is unavailable so I don't know what version they are using)- Hide quoted text - - Show quoted text - Hi, The source workbook has had the colour palette customised. This explains the different colours, but same colour index. If you want the pasted data to have the same colouring, the easiest way is probably to go 'Tools' - 'Options' - 'Colour' while the new workbook is active, and use the 'Copy colors from' option. (This is assuming Excel 2003 or lower, can't remember where the option has been moved to in 2007). Cheers,- Hide quoted text - - Show quoted text - Thanks! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shade differences in excel file
Thanks! On Apr 9, 9:56*pm, "Gary Keramidas" <GKeramidasATmsn.com wrote: try going to tools/options and on the color tab, click reset and see if that helps -- Gary wrote in message ... I received an excel file that has a light grey shading. *But when I copy and paste the format to an excel file that I created, the shading comes out light yellow. *I ran some code to tell me what the Interior.ColorIndex is and it returned 19 for both the grey cell and the light yellow cell. What's causing the difference? *Is is simply a difference in excel versions? *I am working from Excel 2003 (the person I received the file from is unavailable so I don't know what version they are using)- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
shade one cell that will shade multiple cells | Excel Discussion (Misc queries) | |||
opening an excel file differences - time | Excel Discussion (Misc queries) | |||
Shade Active Cell - Shade the cell the cursor is in only while in | Excel Programming | |||
Differences in the way a .xls file is opened | Excel Programming | |||
Opening CSV file causes date differences | Excel Programming |