Thank you for your prompt responses - you confirmed my suspicions that this
couldn't be done.

I appreciate all your help.
Regards
--
Janet


"Janet" wrote:

Hi Folks
One of my colleagues is using VLookup to identify data. Is it possible for
the Lookup to not only pickup the contents of the field, but also the
formatting?

I suggested he use Conditional Formatting, but he needs approx 200 colours
which aren't available in Conditional Formatting.

thanks for all your help.
--
Janet