Thanks for the feedback. What I'm looking for is a cell with a formula that
reflects contents of the active cell as it moves throughout the spreadsheet?

"Dave Peterson" wrote:

Formulas return values -- not formats.

=c2
or
=if(c2="","",c2)

would return the value from C2.

pskwaak wrote:

Excel 2007 - I need a formula for cell K2 that references the cell value of
the active row, column C. I would also like it to include the format of the
referenced cell, if possible.

--

Dave Peterson