ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formatting results of formulas within merged cells (https://www.excelbanter.com/excel-discussion-misc-queries/116419-formatting-results-formulas-within-merged-cells.html)

jondlieber

Formatting results of formulas within merged cells
 
I would like to bold the results of a formula within a merged cell.

Bernard Liengme

Formatting results of formulas within merged cells
 
And what is stopping you?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"jondlieber" wrote in message
...
I would like to bold the results of a formula within a merged cell.




jondlieber

Formatting results of formulas within merged cells
 
Okay, I'm using vlookup between cells being merged from sheet 1 in order to
allow for the lookup value (sheet 2) to expand or contract based on the text
from the list returned. My formula is:

=Sheet1!B45&VLOOKUP(A35,Sheet2!A1:B38,2)&Sheet1!B4 8

Is it possible to bold the results of the lookup value within the merged cell?

"Bernard Liengme" wrote:

And what is stopping you?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"jondlieber" wrote in message
...
I would like to bold the results of a formula within a merged cell.






All times are GMT +1. The time now is 07:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com