| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keeping the format when referencing cells?
I am referecing cells b/w multiple sheets with the "Master" sheet holding all
of the data. So the referencing in Sheet 2 looks like "=MASTER!A1", but the problem is that when the information is placed into Sheet 2 the formatting doesn't follow. So the Master Sheet may have a Blue font and the font in Sheet 2 will be black. Any help? -- Brad |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Keeping the format when referencing cells?
Formulas can return only values not formats
Can us use Conditional Formatting ? best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Beard" wrote in message ... I am referecing cells b/w multiple sheets with the "Master" sheet holding all of the data. So the referencing in Sheet 2 looks like "=MASTER!A1", but the problem is that when the information is placed into Sheet 2 the formatting doesn't follow. So the Master Sheet may have a Blue font and the font in Sheet 2 will be black. Any help? -- Brad |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Keeping the format when referencing cells?
I guess I can, but will it work for what I am trying to do?
-- Brad "Bernard Liengme" wrote: Formulas can return only values not formats Can us use Conditional Formatting ? best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Beard" wrote in message ... I am referecing cells b/w multiple sheets with the "Master" sheet holding all of the data. So the referencing in Sheet 2 looks like "=MASTER!A1", but the problem is that when the information is placed into Sheet 2 the formatting doesn't follow. So the Master Sheet may have a Blue font and the font in Sheet 2 will be black. Any help? -- Brad |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why will my cells not format? | New Users to Excel | |||
| converting general cells format to text | Excel Discussion (Misc queries) | |||
| Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
| format cells having text | Excel Discussion (Misc queries) | |||
| Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Linear Mode
