V-lookup w/formatting

[lmcghee]

Please bear with my statement below and assist.

I have 2 sheets with a common number on each for vlookup, but there is coloring that I would like to be on the first tab from the 2nd sheet do you know how that could be brought over?

 

[zookeepertx]

I asked the same basic question yesterday & was told that it can't be done with a vlookup. It would require VBA.