formatting of cells used as abs or rel reference is lost

M

mnoll

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?
 
S

Sheeloo

Formulas do not transfer formatting...

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

Sheeloo

Formulas do not transfer formatting...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Capturing Formatting with VLookup 1
Maintain Formatting with Formulas 1
protect cell formatting 3
How do I preserve text color when combining cell data 3
formatting a cell the same as the source cell from a lookup table 2
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Exporting conditional formatting rules 12
Inherit formatting from adjacent cells 2

Top