Is it possible in a vlookup to pull formatting too? Like colors?

[Neal Hammond]

Just was curious if doing a vlookup if I could pull colors... For example if
I define 1 to equal GREEN (like a green background) and 2 to equal Yellow
(with Yellow Background), 3 equal RED with REd background on one sheet...

Was curious if doing a Vlookup that each time someone entered a 1,2, 3 if it
would pull the COLOR. That's what the boss is after.

Thanks,
Neal

 

[Dave Peterson]

Nope.

Formulas return values, not this kind of formatting.

 

[JLGWhiz]

You would have to format the results of the VLookup by putting them in a
range that can be formatted.