In Excel 2007 I know that if you have a cell containing text that you can change the color of parts of that text like
This is the text in my cell and this is red text

But I have a cell with a formula that adds text to the end based on a conditional. I can't see any way to change the text color in this situation. Any tips? I basically want this formula:

=D_Notes & TEXT(CHAR(10),) & IF(Terms = "Budgetary Estimate Only", "Quote is budgetary only and is subject to change pending final design.","")