keep formatting when referencing cells

[Beard]

when referencing cells, is there a way to keep the formatting (font color,
etc.)? Thanks.

 

[Dave Peterson]

Excel's formulas return values--not that kind of formatting.