| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet formatting (fill colors & text colors) disappeared | Excel Discussion (Misc queries) | |||
| Can I pull in the filename used in Vlookup from another cell? | Excel Worksheet Functions | |||
| Pull individual cell background colors from workbook to wrkbk | Excel Discussion (Misc queries) | |||
| VLookup / pull data from 1 sheet to another | Excel Discussion (Misc queries) | |||
| Using Vlookup to pull data from another workbook | Excel Programming | |||
Hybrid Mode
