Hi,
Have someone used any workaround to show multi-color characters in a cell that are actually returned by a formula i.e. is retaining the formula as well.
Example:
in Cell A3 I have the formula "=B3&C3" and the result of the formula is "Imran Rawalpindi". I want to show this as:
Imran Rawalpindi
Hope I am clear.
Best Regards
Imran Bhatti
Teach me Excel VBA
Certainly not possible without VBA - shall I move the thread?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Not possible with VBA either. You cannot format part of a cell that contains a formula.
Thanks, Fluff13
I had reached the same conclusion but just wanted to know if someone has what I don't know.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks