Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Bold part of formula results
Windows XP Professional
Office 2000 I have a formula that produces a sentence based on the value of a cell: =IF(H18=0,CONCATENATE("Shpt Volume Increased ",TEXT(H18,".0%")," Y-O-Y"),CONCATENATE("Shpt Volume Decreased ",(TEXT(-H18,".0%"))," Y-O-Y")) I want the word "Increased" or the word "Decreased" to be bold in the resultant cell. Does anyone know the correct way to achieve this? Thanks in advance for any help you may provide! Rita Palazzi Senior Engineer / Global Trade Services FecEx Express |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
What instead of an array formula part 2 | Excel Discussion (Misc queries) | |||
Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |