Preserving data formatting when using VLOOKUP
 

Hello!
How do I preserve font type and color formatting when using VLOOKUP
For e.g. I am looking up data that has variety of fonts and colors
Conditional formatting is limited to only 3 conditions. Is there a wa
to programmatically preserve formatting when using VLOOKUP? Pleas
enlighten

--
shasha
-----------------------------------------------------------------------
shashak's Profile: http://www.excelforum.com/member.php...fo&userid=1626
View this thread: http://www.excelforum.com/showthread.php?threadid=27700

Preserving data formatting when using VLOOKUP
 

In general
Vlookup (other functions) just returns the value, not the font type or
formatting.

--
Regards,
Tom Ogilvy

"shashak" wrote in message
...

Hello!
How do I preserve font type and color formatting when using VLOOKUP?
For e.g. I am looking up data that has variety of fonts and colors.
Conditional formatting is limited to only 3 conditions. Is there a way
to programmatically preserve formatting when using VLOOKUP? Please
enlighten.


--
shashak
------------------------------------------------------------------------
shashak's Profile:
http://www.excelforum.com/member.php...o&userid=16265
View this thread: http://www.excelforum.com/showthread...hreadid=277005

Preserving data formatting when using VLOOKUP
 

Can you put the conditional formatting conditions on the cell(s) that use the
vlookup?

"shashak" wrote:


Hello!
How do I preserve font type and color formatting when using VLOOKUP?
For e.g. I am looking up data that has variety of fonts and colors.
Conditional formatting is limited to only 3 conditions. Is there a way
to programmatically preserve formatting when using VLOOKUP? Please
enlighten.


--
shashak
------------------------------------------------------------------------
shashak's Profile: http://www.excelforum.com/member.php...o&userid=16265
View this thread: http://www.excelforum.com/showthread...hreadid=277005