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

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.
 
D

Don Guillett

Can't with a formula. Formulas only return values. You would need to use a
macro to FIND, COPY, PASTE SPECIAL
 
Top