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