Keeping source formatting from a referenced cell.
 

I have a report that I reference definitions from a different worksheet
within the report. On the definition sheet, I have the word being defined in
bold and the actual definition non-bold. However when I reference it from
another worksheet excel only allows me to have it all bold or no bold. I've
tried to "keep source formatting" to no avail. Any help would be appreciated.

Keeping source formatting from a referenced cell.
 

Formulas return values--not formats.

Can you copy and paste instead?

Nelson B. wrote:

I have a report that I reference definitions from a different worksheet
within the report. On the definition sheet, I have the word being defined in
bold and the actual definition non-bold. However when I reference it from
another worksheet excel only allows me to have it all bold or no bold. I've
tried to "keep source formatting" to no avail. Any help would be appreciated.

--

Dave Peterson

Keeping source formatting from a referenced cell.
 

A formula cannot affect the formatting of a cell.

Pete

On Aug 26, 1:55*pm, Nelson B.
wrote:
I have a report that I reference definitions from a different worksheet
within the report. *On the definition sheet, I have the word being defined in
bold and the actual definition non-bold. *However when I reference it from
another worksheet excel only allows me to have it all bold or no bold. *I've
tried to "keep source formatting" to no avail. *Any help would be appreciated.

Keeping source formatting from a referenced cell.
 

I could, but I have many reports referencing these definitions, and my hope
was to be able to make one change and have all the other reports update.
Copying and pasting is certainly a possibility, but more time consuming.
Thanks for the reply.

"Dave Peterson" wrote:

Formulas return values--not formats.

Can you copy and paste instead?

Nelson B. wrote:

I have a report that I reference definitions from a different worksheet
within the report. On the definition sheet, I have the word being defined in
bold and the actual definition non-bold. However when I reference it from
another worksheet excel only allows me to have it all bold or no bold. I've
tried to "keep source formatting" to no avail. Any help would be appreciated.

--

Dave Peterson