That would require some VBA code
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Janet" wrote in message
...
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