Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Really basic question! Cell colours change when emailed.
I have good old Office 2003.
My colleagues have Office 2007. When I am sent an Excel file by email with cells filled with colours, the colours are changed when I open the file. Just received email with spreadsheet attached with (I am told) Yellow/ Amber/ Green cell colours. However, when I open the file the colours are now Yellow/ Amber/ Yellow!! Any explanation or help gratefully received. Thanks De1b0y |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Really basic question! Cell colours change when emailed.
Probably has to do with Conditional Formating. If the cells contain dates,
you could be opening the file on a date that meets the criteria to change colors. Or some other criteria. Check the conditional format dialogue box. "De1b0y" wrote: I have good old Office 2003. My colleagues have Office 2007. When I am sent an Excel file by email with cells filled with colours, the colours are changed when I open the file. Just received email with spreadsheet attached with (I am told) Yellow/ Amber/ Green cell colours. However, when I open the file the colours are now Yellow/ Amber/ Yellow!! Any explanation or help gratefully received. Thanks De1b0y |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Really basic question! Cell colours change when emailed.
Thanks.
Have looked at this and I have no conditional formatting set. So the problem remains a mystery. :-) De1b0y "JLGWhiz" wrote: Probably has to do with Conditional Formating. If the cells contain dates, you could be opening the file on a date that meets the criteria to change colors. Or some other criteria. Check the conditional format dialogue box. "De1b0y" wrote: I have good old Office 2003. My colleagues have Office 2007. When I am sent an Excel file by email with cells filled with colours, the colours are changed when I open the file. Just received email with spreadsheet attached with (I am told) Yellow/ Amber/ Green cell colours. However, when I open the file the colours are now Yellow/ Amber/ Yellow!! Any explanation or help gratefully received. Thanks De1b0y |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Really basic question! Cell colours change when emailed.
This was an incompatibility between 2003 and 2007 that has driven me crazy
for months. It looks like they have fixed it in Office 2007 SP1, just released a few days ago. "De1b0y" wrote: Thanks. Have looked at this and I have no conditional formatting set. So the problem remains a mystery. :-) De1b0y "JLGWhiz" wrote: Probably has to do with Conditional Formating. If the cells contain dates, you could be opening the file on a date that meets the criteria to change colors. Or some other criteria. Check the conditional format dialogue box. "De1b0y" wrote: I have good old Office 2003. My colleagues have Office 2007. When I am sent an Excel file by email with cells filled with colours, the colours are changed when I open the file. Just received email with spreadsheet attached with (I am told) Yellow/ Amber/ Green cell colours. However, when I open the file the colours are now Yellow/ Amber/ Yellow!! Any explanation or help gratefully received. Thanks De1b0y |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Don't change cell colours when adding or deleting rows? | Excel Discussion (Misc queries) | |||
is there a formula to auto change cell colours | Excel Discussion (Misc queries) | |||
Excel will not change cell border colours | Excel Discussion (Misc queries) | |||
automatically change cell colours | Excel Discussion (Misc queries) | |||
Excel 2003 font colours and cell colours | Excel Discussion (Misc queries) |