Formulas don't return this kind of formatting. They return values.

You could copy|paste or have a macro do it.

sirjibby wrote:

When you tell a cell to display the contents of a cell from another worksheet
(eg. if in a cell from Sheet2 I put the formula ='Sheet1'!A1), how do you
also get it to use the formatting of that cell?

Thanks in advance for looking!

--

Dave Peterson