No

Formulas cannot copy formatting.

If the formatting on source sheet is from Conditional Formatting, you could
CF the target cell the same.

Or use two steps.............copy values then copy formats.


Gord Dibben MS Excel MVP

On Tue, 12 Aug 2008 10:35:01 -0700, marco g 3284
wrote:

i'm trying to copy a cell (both text and format) from one tab to another tab
within the same document but keep getting just the text. is there a formula
aside from '=Sheet1!' that will work for it?