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