Hello,
I have this issue in years to enhance the string using If ...then function.
I could use conditional formating for entire string, but I want to enhance
string partically.
For example: If A1=10, "This is correct","This is not correct"
I like the string (answer) to be "This is correct"
"This is not correct]"
I know I can add color/bold/italic to a string in a cell but not string from the function.
Is that possible using function or VBA?
Thanks
Last edited by Rocky2013; 04-13-2015 at 07:34 AM.
Does A10 contain a formula or a constant??
Gary's Student
I think, it is possible. Now, I could not use excel by my computer.But you can try save a macro.
First of all, start macro for saving, after that write "This is correct" to a cell. Then, change it's color. And, stop macro.
When you open the code, you will see what to do to change color of cells.
Hello Jakobshavn,
A1 will be a formula, It is not necessory a number, but it could be a string. I just make up an example.
I use the result in A1 to initate an error or message for the reader to be award the result in A1.
Another example the formula can be liked this .... If(A1=10, "", "Incorrect, Please check the input.")
if A10 is not 10, then I want the result to be ... Incorrect, Please check the input.
If it is VBA, I like to have a real time without click a command button.
Hello oglcngcmn,
Macro recording does not work for me using a command button to run the code; unless if I can modify the code to eliminate
the use of a command buuton if I know how.
Thanks
Last edited by Rocky2013; 04-12-2015 at 10:25 AM.
You cannot format the output from a formula. You can only apply formatting to sub-strings of text values. You could probably do it with VBA.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hello All,
It seems complicate. What I am have been doing is to use conditional formating to highlight the entire string,
I will continue to use this way.
This request is a nice to have just to catch the attention on important text rather than reading the whole string.
Maybe a new feature add to the next update of Excel.
Perhaps something like this could be a possible solution?
Not the best of code so there is certainly room for improvement if somebody has a better idea.
Please Login or Register to view this content.
Alf
@Alf: you could generalise it into a Worksheet Change event handler.
Regards, TMS
Please Login or Register to view this content.
Hi TMS
Yes much better but I would like to get it down to a few line of code. Perhaps if the OP hade 3 cell in his worksheet with text "This is", "correct", "not correct" with the propper font and color and just use cell1 & " " & "cell2 & " and cell1 & " " & cell3 in order to get the desired string.
Alf
@Alf: Thanks for the feedback.
OK, maybe a little shorter. Not sure I can it get it better than this:
Please Login or Register to view this content.
Regards, TMS
I will use real time change VBA from TMS's code for immediate use but
Alf'code using command button is also nice to have to service for other purpose.
I thought I gave up on this, but your help is very appreciate. Both codes work.
Thank you,
You're welcome. Thanks for the rep.
Hello,
I already changed to "SOLVED". But last minute thought, what is the code to add a hyberlink to "Correct" and
"incorrect" or the whole sentense because sometime I use If.. then to give the correct answer with a hyperlink
to a web site fo getting the information.
Thanks again
Hello,
I already changed to "SOLVED". But last minute thought, what is the code to add a hyberlink to "Correct" and
"incorrect" or the whole sentense because sometime I use If.. then to give the correct answer with a hyperlink
to a web site fo getting the information.
Thanks again
Don't know off the top of my head. Think it's a new question really and warrants a new thread, with maybe a little more detail about what the URL needs to look like, etc.
Regards, TMS
I prefect just the word(s) not a whole sentense if possible. I did quick searched after I added SOLVED.
I was thinking Do-it-myself, then I got lost with the codes. For the example, I would just use http://www.Yahoo.com
and http://www.Google.com. The link will not have underline if possible. I can change them later.
Thanks
Last edited by Rocky2013; 04-13-2015 at 08:01 AM.
OK, I give in ...
Please Login or Register to view this content.
Regards, TMS
Thanks.
This post is finally SOLVED.
Regards,
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks