Hi, can anyone help?
I am using the VLOOKUP function in a cell, however, I would like the value returned to also retain the text format from the table (eg colour and bold). I have attached a simple example (to demonstrate the point) where cell B14 should have the word 'French' in bold red.Example.xlsx
This cannot be done using built-in Excel functions. Based on your example I think you need a macro. Copying character-by-character formatting is more complicated than just doing it for the whole cell, so writing the macro would be a little bit of work.
Are you open to a VBA solution?
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Hi Jeff,
I suspected this might be the case! I'm happy to give VBA a go as I've recently been dabbling a bit with VBA, but I'm not experienced enough to dive in a write the code without a lot of research/time, so any help would be gratefully received.
Thanks,
Matt
Sorry to bear bad news. I started to look at this and realized that this cannot be done, not even with a macro. You cannot format individual characters that are the result of a formula.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks