Preserving data formatting when using VLOOKUP

  • Thread starter Thread starter shashak
  • Start date Start date
S

shashak

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
 
In general
Vlookup (other functions) just returns the value, not the font type or
formatting.
 
Can you put the conditional formatting conditions on the cell(s) that use the
vlookup?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup formatting problem 1
VBA userform Vlookup Excel 1
Conditional Formatting macro: simple, but doesn't work 6
Inconsistent behavior when applying conditional formats 3
Cell values not being properly evaluated by VLOOKUP() orSUMPRODUCT()... why? 1
Lookup and Enter Value to Other Tab on Change in Cell 0
conditional formatting test 1
Defining a dynamic table_array for vlookup 9

Back
Top