Colouring text within a formula

[Gary Allibone]

Hi Everyone,

Any chance anyone knows what I need to add to the
following formula so that the result 'Ready to go' is
green or the result 'Not Rec'd' is Red.

="UCS UNT July Sign-Off"&IF('General Info'!
I7="Completed","- Ready to go","- Not Rec'd")

Many Thanks,
Gary

[David Rose]

>.
>
You can apply conditional formatting to the cell that
contains the above formula. It will control cell and text
colour. Go to Format/Conditional Formatting... and set up
your formulas to check the content of I7. The cell and
text colours will change depending on what I7 contains.

[Peo Sjoblom]

Select I7 on sheet General Info, give it a name (lets call it MyCell)
Now select the cell with the formula, do format conditional formatting,
select formula is and use

=MyCell="Completed"

click the format button in the same dialogue box, select fonts (preferably
bold
and green), click OK, now click add and repeat but use

=MyCell<>"Completed"

repeat but choose red fonts.

click OK twice

Note that you have to give the cell a name (you cannot use the cell
reference as in
'General Info'!I7) when you are doing this from another sheet (I assumed you
did since you
included the sheet name)

--

Regards,

Peo Sjoblom

"Gary Allibone" <gary.j....@aexp.com> wrote in message
news:0a9b01c36e2c$7f666820$a501...@phx.gbl...