It's mot possible within a formula. This post will clarify any doubts.

http://www.excelforum.com/excel-prog...mat-color.html

--
Alex
*Remember to click "yes" if this post helped you. Thank you!



"BillCPA" wrote:

I have a concatenate formula - CONCATENATE("blahblah",A4,"moreblah") - that
pulls in part of the string from a cell (A4). Is there any way to change the
characteristics of just the A4 value (bold, red, etc.) within the concatenate?

--
Bill @ UAMS