| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format the outcome of a formula
I have a formula that pulls in numbers into a text string but i want to
underline or bold the numbers being pulled in and selected parts of the text. Is this possible? eg cell formula ="john is "&A1&" years old" where cell A1 is 10 returns "john is 10 years old" ideally i want the 10 to be bold and the old to be underlined even if the cell the number is being drawn from (A1 in this case) is bold or underlined the format is not pulled into the result of the formula many thanks (nb i have excel 2002) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format a cell if the formula is removed | Excel Worksheet Functions | |||
| Format cells with a formula (7 conditions). | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| How do I copy a conditional format that uses a formula in a serie. | Setting up and Configuration of Excel | |||
| How do I format a character from a result of formula in excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
