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