Custom Formula Requires Custom Formatting

Y

Yogi_Bear_79

As suggested from a previous post I am using the following formula to fill a
merged cell.

="(AO) "&'Source Doc'!B49&REPT(" ",49-LEN('Source Doc'!B49&'Source
Doc'!C49))&'Source Doc'!C49


I have a need to make the (AO) Bold & Italiacs, then the data from 'Source
Doc'!B49 should be bold and dark blue. Leaving the data from C49 as
formatted
 
D

Dave Peterson

Cells that contain formulas can't have this kind of character by character
formatting.
 

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

Mail Merge query 1
Cheque Print 0
Word 2007 with Excel linked objects 0
formula in conditional formatting with dates 3
Keep original cell formatting when using transpose array formula 1
Conditional formatting (by Formula) - few questions 15
Strange blue background. 3
Word Merge labels 2

Top