Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple format single cell that has formula's
Is there a way to have multiple formats in a single cell that has formula's?
What I'm doing specifically is attaching several strings together and it would be great to be control the format in the cell. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple format single cell that has formula's
Try using conditional formatting. It will take up to three conditions and
will format according to the criteria you specify. You can add a fourth by setting a default format that Excel will use if none of your other criteria are met. -- HTH JonR "Brad" wrote: Is there a way to have multiple formats in a single cell that has formula's? What I'm doing specifically is attaching several strings together and it would be great to be control the format in the cell. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple format single cell that has formula's
Or unlimited in XL2007
-- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "JonR" wrote in message ... Try using conditional formatting. It will take up to three conditions and will format according to the criteria you specify. You can add a fourth by setting a default format that Excel will use if none of your other criteria are met. -- HTH JonR "Brad" wrote: Is there a way to have multiple formats in a single cell that has formula's? What I'm doing specifically is attaching several strings together and it would be great to be control the format in the cell. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple format single cell that has formula's
My question is this
I want the first word to be bold - second word to be italizied - third to be underlined ,... Conditional formatting will change the whole cell to be whatever you specify - but will not change only a portion of the cell to be bold another portion to be something different If there are no formulas - one can change the text as I described above. Was wondering if there was a way with formulas? "JonR" wrote: Try using conditional formatting. It will take up to three conditions and will format according to the criteria you specify. You can add a fourth by setting a default format that Excel will use if none of your other criteria are met. -- HTH JonR "Brad" wrote: Is there a way to have multiple formats in a single cell that has formula's? What I'm doing specifically is attaching several strings together and it would be great to be control the format in the cell. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple format single cell that has formula's
Brad
Formulas can only return values, they cannot change formatting etc. Formats only operate on entire cells, not part of it and whilst you can manually change part of the cell, bold, etc there is no way to do this without VBA code -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "Brad" wrote in message ... My question is this I want the first word to be bold - second word to be italizied - third to be underlined ,... Conditional formatting will change the whole cell to be whatever you specify - but will not change only a portion of the cell to be bold another portion to be something different If there are no formulas - one can change the text as I described above. Was wondering if there was a way with formulas? "JonR" wrote: Try using conditional formatting. It will take up to three conditions and will format according to the criteria you specify. You can add a fourth by setting a default format that Excel will use if none of your other criteria are met. -- HTH JonR "Brad" wrote: Is there a way to have multiple formats in a single cell that has formula's? What I'm doing specifically is attaching several strings together and it would be great to be control the format in the cell. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple format single cell that has formula's
So you can do it in VBA.
Since you can't record a macro to do this. Would you specify what positions would have what formats? Do you have a simple procedure that I could look at? "Nick Hodge" wrote: Brad Formulas can only return values, they cannot change formatting etc. Formats only operate on entire cells, not part of it and whilst you can manually change part of the cell, bold, etc there is no way to do this without VBA code -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "Brad" wrote in message ... My question is this I want the first word to be bold - second word to be italizied - third to be underlined ,... Conditional formatting will change the whole cell to be whatever you specify - but will not change only a portion of the cell to be bold another portion to be something different If there are no formulas - one can change the text as I described above. Was wondering if there was a way with formulas? "JonR" wrote: Try using conditional formatting. It will take up to three conditions and will format according to the criteria you specify. You can add a fourth by setting a default format that Excel will use if none of your other criteria are met. -- HTH JonR "Brad" wrote: Is there a way to have multiple formats in a single cell that has formula's? What I'm doing specifically is attaching several strings together and it would be great to be control the format in the cell. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple format single cell that has formula's
Are you trying to format the results a concatenate formula or something like
that? Interesting problem. I've not tried that before. It might help if I knew what you were trying to format and the conditions you are trying to satisfy. -- HTH JonR "Brad" wrote: My question is this I want the first word to be bold - second word to be italizied - third to be underlined ,... Conditional formatting will change the whole cell to be whatever you specify - but will not change only a portion of the cell to be bold another portion to be something different If there are no formulas - one can change the text as I described above. Was wondering if there was a way with formulas? "JonR" wrote: Try using conditional formatting. It will take up to three conditions and will format according to the criteria you specify. You can add a fourth by setting a default format that Excel will use if none of your other criteria are met. -- HTH JonR "Brad" wrote: Is there a way to have multiple formats in a single cell that has formula's? What I'm doing specifically is attaching several strings together and it would be great to be control the format in the cell. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple format single cell that has formula's
Simple Example
in a1 =B1&", "&C1&", "&D1 B1 = Peter C1 = Paul D1 = Mary in A1 Peter needs to be in Times New Roman 10 point - bold - red Paul needs to be in Arial - underlined 12 point - blue Mary needs to be 18 font italicizied - purple My problem isn't quite this easy - but the concept is the same. "JonR" wrote: Are you trying to format the results a concatenate formula or something like that? Interesting problem. I've not tried that before. It might help if I knew what you were trying to format and the conditions you are trying to satisfy. -- HTH JonR "Brad" wrote: My question is this I want the first word to be bold - second word to be italizied - third to be underlined ,... Conditional formatting will change the whole cell to be whatever you specify - but will not change only a portion of the cell to be bold another portion to be something different If there are no formulas - one can change the text as I described above. Was wondering if there was a way with formulas? "JonR" wrote: Try using conditional formatting. It will take up to three conditions and will format according to the criteria you specify. You can add a fourth by setting a default format that Excel will use if none of your other criteria are met. -- HTH JonR "Brad" wrote: Is there a way to have multiple formats in a single cell that has formula's? What I'm doing specifically is attaching several strings together and it would be great to be control the format in the cell. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple format single cell that has formula's
Formulas don't support this kind of formatting.
If you convert it to values, you can change the formatting the way you like. Brad wrote: Simple Example in a1 =B1&", "&C1&", "&D1 B1 = Peter C1 = Paul D1 = Mary in A1 Peter needs to be in Times New Roman 10 point - bold - red Paul needs to be in Arial - underlined 12 point - blue Mary needs to be 18 font italicizied - purple My problem isn't quite this easy - but the concept is the same. "JonR" wrote: Are you trying to format the results a concatenate formula or something like that? Interesting problem. I've not tried that before. It might help if I knew what you were trying to format and the conditions you are trying to satisfy. -- HTH JonR "Brad" wrote: My question is this I want the first word to be bold - second word to be italizied - third to be underlined ,... Conditional formatting will change the whole cell to be whatever you specify - but will not change only a portion of the cell to be bold another portion to be something different If there are no formulas - one can change the text as I described above. Was wondering if there was a way with formulas? "JonR" wrote: Try using conditional formatting. It will take up to three conditions and will format according to the criteria you specify. You can add a fourth by setting a default format that Excel will use if none of your other criteria are met. -- HTH JonR "Brad" wrote: Is there a way to have multiple formats in a single cell that has formula's? What I'm doing specifically is attaching several strings together and it would be great to be control the format in the cell. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple hyperlinks in a single cell | Excel Discussion (Misc queries) | |||
Can I format an entire row based on the value of a single cell? | Excel Discussion (Misc queries) | |||
can a single cell contain multiple numbers? | Excel Worksheet Functions | |||
How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
Using a single cell in multiple formulas | Excel Worksheet Functions |