| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format text within a formula
I am using Excel 2007 SP1.
I have a formula that I want to format the font color of specific text sections. Here is my formula: ="change. Payback period will net you " & IF(OFFSET(NextBuy!$AC$6,ForcastDays,0,1,1)0,DOLLA R(ABS(OFFSET(NextBuy!$AC$6,ForcastDays,0,1,1)),0) & " more than",IF(OFFSET(NextBuy!$AC$6,ForcastDays,0,1,1)<0 ,DOLLAR(ABS(OFFSET(NextBuy!$AC$6,ForcastDays,0,1,1 )),0) & " less than"," no difference from")) & " ROI, during the next" What I want to do is format the DOLLAR parts as green for greater than zero, and red for less than zero. How can I do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format text in formula line | Excel Worksheet Functions | |||
| How do I format text so that when the formula delivers the mixeddata, it looks right | Excel Discussion (Misc queries) | |||
| format text color within formula | Excel Worksheet Functions | |||
| How do I format text that is part of a formula? | Excel Discussion (Misc queries) | |||
| Display Format with Text & Formula | Excel Worksheet Functions | |||
Threaded Mode
