Vlookup Question

When using Vlookup can it be programed to also copy the format of the cell being returned?

Specifically I need the number in the cell being looked up and the color of the cell, the number returns the rating of the item and the color explains the condition its in.