| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to format a cell that contains formula
Thanks. please refere to this link for the answer...
http://www.microsoft.com/office/comm...4-f97aa7ba95e4 "JE McGimpsey" wrote: You can't do that without using an Event macro to concatenate and format the cell. Formulae can't change formatting, they only return values to their calling cells. In article , Sam wrote: The prevouse post doesn't help my new problem. when i Concatenate all the data into one cell they lose their color and boldness. i need to keep the color and other formatting. how can i do that? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Colors | Excel Worksheet Functions | |||
| text and formula in the same cell - how do I format this cell?? | Excel Discussion (Misc queries) | |||
| Cell References | Excel Discussion (Misc queries) | |||
| Format Issue | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
