Keeping source formatting from a referenced cell.

N

Nelson B.

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.
 
N

Nelson B.

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.
 

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

Conditional Formatting Issue 3
formatting a cell the same as the source cell from a lookup table 2
Copy Source Cells to Destination Cells Only when a Change Occurs 2
protect cell formatting 3
keeping format of a referenced cell 4
Can you prevent Copy-Paste from changing formatting without macros 5
bold text of referenced cell show in formula cell 1
Formatting not protected when paste 7

Top