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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format text within a formula
hi,
use conditional formating, within the home menu go to Styles (5th tab on top), conditional formating, highlight cells rules and there apply your rules If this helps please click yes, thanks "Larry Horsley" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format text within a formula
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format text within a formula
On Wed, 3 Jun 2009 05:08:01 -0700, Eduardo
wrote: hi, use conditional formating, within the home menu go to Styles (5th tab on top), conditional formating, highlight cells rules and there apply your rules How does that format just the Dollar parts? --ron |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format text within a formula
Thanks Ron, I missunderstood the question, you are right
"Ron Rosenfeld" wrote: On Wed, 3 Jun 2009 05:08:01 -0700, Eduardo wrote: hi, use conditional formating, within the home menu go to Styles (5th tab on top), conditional formating, highlight cells rules and there apply your rules How does that format just the Dollar parts? --ron |
Reply |
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 |