ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   formatting of cells used as abs or rel reference is lost (https://www.excelbanter.com/excel-discussion-misc-queries/231464-formatting-cells-used-abs-rel-reference-lost.html)

mnoll

formatting of cells used as abs or rel reference is lost
 
How do I maintain the originally formatting of text in a cell (ex. certain
characters - but not all - a certain color or bold etc) when using this cell
as an absolute reference?
--
mn

Sheeloo

formatting of cells used as abs or rel reference is lost
 
Formulas do not transfer formatting...

So you can not get the formatting of A1 by using a refernce (abosolute or
relative)

"mnoll" wrote:

How do I maintain the originally formatting of text in a cell (ex. certain
characters - but not all - a certain color or bold etc) when using this cell
as an absolute reference?
--
mn



All times are GMT +1. The time now is 07:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com