Hi,
Is it possible to do partial change of font color in Concatenated cell.
example:
used formula =CONCATENATE("M"&T112&"-"&H112&CHAR(10)&"LFT"&"-"&W112)
where I want to change the font color of "M"&T112
and the this is always consist of two alphabet only ( MC, MB etc etc)
Can any one help me doing this along with CONCATENATE formula.
I think this only possible via VBA.
Take a detailed look here
http://www.mrexcel.com/forum/excel-q...part-cell.html
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks