ExcelBanter - keep formatting when referencing cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - keep formatting when referencing cells (https://www.excelbanter.com/excel-discussion-misc-queries/72729-keep-formatting-when-referencing-cells.html)

Beard

keep formatting when referencing cells

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

Dave Peterson

keep formatting when referencing cells

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

Beard wrote:

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

--

Dave Peterson

All times are GMT +1. The time now is 10:07 PM.