How to vlookup and bring over fill colors as along with the data

  • Thread starter Thread starter dadams
  • Start date Start date
D

dadams

I am using vlookup to bring over text from File A to File B. File A has
cells highlighted with different fill colors. When I bring over the data, I
want to bring over the fill color as well and haven't figured out how to do
that.
 
Can't with a formula. Formulas only return values. You would need to use a
macro to FIND, COPY, PASTE SPECIAL
 

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 and bring the "font color" of the cell across? 1
vlookup to another worksheet 3
Need VLOOKUP to Work Two Ways 0
Can VLookup pull text format from data 1
How does one use a formula to bring over the formatting as well 1
VLOOKUP - Hyperlinks Vanish 5
Excel Macro to automatically go to the right of the last colored cell 0
Excel Trying to do a vlookup with a nested right function on the array 3

Back
Top