Custom Formula Requires Custom Formatting

  • Thread starter Thread starter Yogi_Bear_79
  • Start date Start date
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
 
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

Formulas 2
VBA to move from one cell to another cell 6
Adding "letters (column headings)" 7
Need Help w/ SUM Formula Syntax 1
Discrepancy between manually formatting sheet vs. using VBA macro 5
formula in conditional formatting with dates 3
Cheque Print 0
Ridiculous Formatting Question 1

Back
Top