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

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

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

Hi Neal,

A formula can only returna value to a cell.

Take a look at Conditional Formatting and format the cell getting the 1, 2
or 3. Use cell Value is equal to and 1, 2 or 3..

HTH
Regards,
Howard



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

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

Nope.

Formulas return values, not this kind of formatting.

Neal Hammond wrote:

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

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

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

"Neal Hammond" wrote:

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