Can colour of text or figures be requested in formules like vlookup so that
what information you called up can be shown in its original colors
Can colour of text or figures be requested in formules like vlookup so that
what information you called up can be shown in its original colors
No, there is no way to have a built-in formula lookup any formatting. You
would need to code this in VBA, probably by the _Calculate event procedure;
you would need to find the cell's precedents and use that to find the
formatting of the source cell, copy it to the target cell. Not an easy task
and I don't have time right now to try to work it out!
--
- K Dales
"Quo Vadis" wrote:
> Can colour of text or figures be requested in formules like vlookup so that
> what information you called up can be shown in its original colors
And on top of that, formulas don't support this kind of character by character
formatting.
You'd have to convert the formula to a value, then do the formatting--and then
find a way to replace the lost formula (worksheet_change???)
K Dales wrote:
>
> No, there is no way to have a built-in formula lookup any formatting. You
> would need to code this in VBA, probably by the _Calculate event procedure;
> you would need to find the cell's precedents and use that to find the
> formatting of the source cell, copy it to the target cell. Not an easy task
> and I don't have time right now to try to work it out!
> --
> - K Dales
>
> "Quo Vadis" wrote:
>
> > Can colour of text or figures be requested in formules like vlookup so that
> > what information you called up can be shown in its original colors
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks