Format a cell with a formula in it.

[creeker69]

Here's what I have in a cell. The cell is right justified so that it will print since the adjacent cells to the left are empty. I need just the value to print in bold.

The cell formula is ="Total number of units > 45 days old is " & SUM(D619) .

The value of D619 happens to be 20.

I want JUST the "20" to appear in bold. Any way to do this? As soon as the "=" sign is entered into a cell, the format buttons go gray and will not work.

 

[SkipVought]

creeker69,

Can't do it with worksheet functions.

Can do it with VBA code.

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[Zathras]

The only way to do this with a formula is to re-structure the worksheet and use two cells:

Put Total number of units > 45 days old is in one cell
Put =SUM(D619) in the cell to the right and make it bold.

Otherwise, as Skip indicated, you can use VBA to put pure text in the cell and selectively highligt the characters you want. But of course, you lose the dynamic action of the formula. You would have to process the worksheet change event for the cells in D619 to continually update the text.

 

[creeker69]

Thanks guys!

I hate hearing I can't but I kinda thought as much. Thanks for the help.

Ron