Making portion of formula BOLDFACE

  • Thread starter Thread starter Dkline
  • Start date Start date
D

Dkline

I have a text formula which ends up being way greater than the 256 character
limit. I am using Excel 97.

The first 2/3rds of the formula a static piece of text of almost 700
characters. To that by formula I am appending one of two sentences. Which
ever piece is appended must be in bold (a legal requirement).

I can't figure out how to make that last piece bold. Is there a function I
can use for the conditional text? Do I need to do this by a macro since I
will know the length of the first portion which has no conditions?
 
A cell containing a formula cannot have formatting applied to
part of the result. You can only apply formatting to the entire
cell.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Dkline wrote...
I have a text formula which ends up being way greater than the 256 character
limit. I am using Excel 97.

The first 2/3rds of the formula a static piece of text of almost 700
characters. To that by formula I am appending one of two sentences. Which
ever piece is appended must be in bold (a legal requirement).

I can't figure out how to make that last piece bold. Is there a function I
can use for the conditional text? Do I need to do this by a macro since I
will know the length of the first portion which has no conditions?
Click to expand...

You can approximate this functionality with VBA. See

http://groups.google.com/group/micr...tions/msg/09007a07b6457942?dmode=source&hl=en
 
Back
Top