hi guys i have some code where i need to make the text bold but not sure how to go about it
the formula isif cell d2 is empty then obviously there will be nothing there ie - hello
Please Login or Register to view this content.
if d2 has steve in it, it should read - hello steve
its the steve part i need in bold
and im not sure
thanks in advance
Last edited by stevecontracts; 02-18-2010 at 05:36 AM.
Not possible. You cannot put a formula in a cell then format "part" of the resulting text string. You can format the entire cell based on "part" of the resulting text string, so you could bold the entire cell if "STEVE" were in the text.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
shame - but thanks for the reply
If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].
(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks