Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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.misc
|
|||
|
|||
![]()
Formulas can't return formatting like this.
You may be able to use some sort of macro that copies and pastes??? Beard wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |