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 |
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 |
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 |
All times are GMT +1. The time now is 01:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com