Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing Text format in a function
Hi Everyone, I have a question. I formula that generates a string result that I would like to do some formating with. I would like to bold the text and change the text color. But I do not want to do it to the whole cell. Just a portion of the text. HERE IS AN EXAMPLE: A1 = 4/3/2006 A3 = 1 _Formula_in_B3_ ="Week "&A3&": " & TEXT($A$1+((A3-1)*7),"[RED][BOLD]Mmm d 'yy") _Formula_Result_in_B3_ Week 1: *Apr 3 '06* I am trying to use the Text formula, but it does not recognize the color request. Any help will be appreciated. thanks BDS -- FirstWizardZedd ------------------------------------------------------------------------ FirstWizardZedd's Profile: http://www.excelforum.com/member.php...o&userid=33506 View this thread: http://www.excelforum.com/showthread...hreadid=533003 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing Text format in a function
Not possible to format part of a formula
-- Regards, Peo Sjoblom http://nwexcelsolutions.com "FirstWizardZedd" <FirstWizardZedd.269ooc_1145039702.6453@excelfor um-nospam.com wrote in message news:FirstWizardZedd.269ooc_1145039702.6453@excelf orum-nospam.com... Hi Everyone, I have a question. I formula that generates a string result that I would like to do some formating with. I would like to bold the text and change the text color. But I do not want to do it to the whole cell. Just a portion of the text. HERE IS AN EXAMPLE: A1 = 4/3/2006 A3 = 1 _Formula_in_B3_ ="Week "&A3&": " & TEXT($A$1+((A3-1)*7),"[RED][BOLD]Mmm d 'yy") _Formula_Result_in_B3_ Week 1: *Apr 3 '06* I am trying to use the Text formula, but it does not recognize the color request. Any help will be appreciated. thanks BDS -- FirstWizardZedd ------------------------------------------------------------------------ FirstWizardZedd's Profile: http://www.excelforum.com/member.php...o&userid=33506 View this thread: http://www.excelforum.com/showthread...hreadid=533003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Changing cell format - for example text to numeric | Excel Discussion (Misc queries) | |||
Using Concatenate function to generate text in Text Box | Charts and Charting in Excel | |||
Changing worksheet cells from within a function | Setting up and Configuration of Excel | |||
TEXT function to format a date in English & French | Excel Worksheet Functions |