VLookup & Formatting
 

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

VLookup & Formatting
 

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

VLookup & Formatting
 

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

VLookup & Formatting
 

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 & Formatting
 

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

VLookup & Formatting
 

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