Vlookup command to pull cell colors

[Cquake]

When using vlookup for a project I am doing some of the data that I pull up also has a cell coloring to it. However when using the vlookup funtion it pulls the data from the location but does not include the cell color. How do I get vlookup to also include the cell color with the data in it?

 

[JoeMo]

VLOOKUP returns a value, but not the formatting of the cell holding that value.

 

[Cquake]

VLOOKUP returns a value, but not the formatting of the cell holding that value.

Thanks, well then I might have to rethink my process and try a different route.