Hi,

It can't.

The only ways you can do this are with a linked picture of two adjacent
cells place in another cell. And that is more trouble than it's worth
and/but it doesn't require conditional formatting.
Or in 2007 by linking a shape to the cell with a formula and then manually
controlling the gradient fill of the text. Again far more work than it's
worth in MHO.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Rick Rothstein" wrote:

The OP asked "can I program the font color "in the same cell" as 2 different colors" on text that is the result of a formula... how will Conditional Formatting allow him to do that?

--
Rick (MVP - Excel)


"Paul Wilson" wrote in message ...
Hi Joe,

Use conditional formatting on the cell. In XL2003 FormatConditional
Formatting; in Xl2007 its on the ribbon in the Styles grouping.

Have a look at the first video on this link
http://www.contextures.com/xlVideos0...#CondFormatRow

if you need further information.

Regards

Paul



"Joe Wildman" <Joe wrote in message
...
Hello everyone, I created a drop down list (Open, Update, Closed) and it
works fine, my question is, can I program the font color "in the same
cell"
as 2 different colors?

eg.: (State: In Black) (Open In Blue)
State: Open

="State: "&IF('Alert Setup'!$C$6="","",'Alert Setup'!$C$6)

PS: I need this so i can copy and paste this into an email with no cell
coding