| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting in a formula
I am trying to format only a certain part of a formula...
Formula is : =IF(ISBLANK('Cabinet Information'!D21),"Stain","Stain - "&'Cabinet Information'!D21) I don't want to bold Stain, only what comes after it - 'Cabinet Information'!D21). Is this possible from inside a formula? Thanks in advance, Pat Canton |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting in a formula
Not within a formula. You would need to copy and then pastespecial/values and
then apply the formats -- Gary''s Student - gsnu200820 "Pat Canton" wrote: I am trying to format only a certain part of a formula... Formula is : =IF(ISBLANK('Cabinet Information'!D21),"Stain","Stain - "&'Cabinet Information'!D21) I don't want to bold Stain, only what comes after it - 'Cabinet Information'!D21). Is this possible from inside a formula? Thanks in advance, Pat Canton |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting in a formula
Nope.
Formulas don't support this kind of character by character formatting. Pat Canton wrote: I am trying to format only a certain part of a formula... Formula is : =IF(ISBLANK('Cabinet Information'!D21),"Stain","Stain - "&'Cabinet Information'!D21) I don't want to bold Stain, only what comes after it - 'Cabinet Information'!D21). Is this possible from inside a formula? Thanks in advance, Pat Canton -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting in a formula
sure if this only driven off a 21 lines of data
you could possilbe go one by one on the conditional formating and go new rule, there is somewher in there were it ill let type specific text and it auto formate that text or text in the range disirered "Pat Canton" wrote: I am trying to format only a certain part of a formula... Formula is : =IF(ISBLANK('Cabinet Information'!D21),"Stain","Stain - "&'Cabinet Information'!D21) I don't want to bold Stain, only what comes after it - 'Cabinet Information'!D21). Is this possible from inside a formula? Thanks in advance, Pat Canton |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting within a formula | Excel Discussion (Misc queries) | |||
| Formula Formatting | Excel Discussion (Misc queries) | |||
| Formatting Within a Formula | Excel Discussion (Misc queries) | |||
| Formatting with a Formula | Excel Discussion (Misc queries) | |||
| Formatting in the formula bar | Excel Discussion (Misc queries) | |||
Hybrid Mode
