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

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

1. No. Formulas ONLY return values
2. You can use a select case macro with a worksheet_change event. 200 colors
sounds a bit confusing...

--
Don Guillett
SalesAid Software

"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

Formulas return values--not formatting.



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

--

Dave Peterson

VLOOKUP returns only values, not formatting......you would need VBA for that.

BTW, how does one tell the difference between 200 colors?

Vaya con Dios,
Chuck, CABGx3



"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

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