Custom Formula Requires Custom Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yogi_Bear_79 - 22 Nov 2006 15:14 GMT

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

Reply to this Message

Dave Peterson - 22 Nov 2006 15:31 GMT

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

> As suggested from a previous post I am using the following formula to fill a
> merged cell.
[quoted text clipped - 5 lines]
> Doc'!B49 should be bold and dark blue. Leaving the data from C49 as
> formatted

Signature

Dave Peterson

Reply to this Message

Yogi_Bear_79 - 22 Nov 2006 16:23 GMT

Bummer, thanks

> Cells that contain formulas can't have this kind of character by character
> formatting.
[quoted text clipped - 10 lines]
>> Doc'!B49 should be bold and dark blue. Leaving the data from C49 as
>> formatted

Reply to this Message

Rate this thread: