Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retain colours of figures using vlookup between pages
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retain colours of figures using vlookup between pages
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retain colours of figures using vlookup between pages
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup across multiple pages | Excel Worksheet Functions | |||
Using VLOOKUP to find colours | Excel Worksheet Functions | |||
vlookup across multiple pages | Excel Worksheet Functions | |||
Changing positive figures to minus figures | Excel Worksheet Functions | |||
Excel 2003 font colours and cell colours | Excel Discussion (Misc queries) |