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

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.

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

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

"dadams" wrote in message
...
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.