Retain colours of figures using vlookup between pages

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Quo Vadis - 20 Jan 2006 14:27 GMT

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

Reply to this Message

K Dales - 20 Jan 2006 14:40 GMT

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!

Signature

- K Dales

> 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

Reply to this Message

Dave Peterson - 20 Jan 2006 18:08 GMT

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???)

> 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;
[quoted text clipped - 6 lines]
> > 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

Signature

Dave Peterson

Reply to this Message