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?