View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Keeping the format when referencing cells?

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