+ Reply to Thread
Results 1 to 4 of 4

Retaining Formatting when using (v)LOOKUP

  1. #1
    Registered User
    Join Date
    09-14-2010
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2007
    Posts
    10

    Retaining Formatting when using (v)LOOKUP

    Hey everyone,

    I have a huge xls sheet with about 2,000 terms and rankings.. of which I need to pull about 100. I have successfully set vlookup to retrieve these, however on the document I'm pulling from, there are background colors for said cells. Is there any way for Excel to return the background color along with the data on the new sheet?

    Thanks a bunch!

    --Russell

  2. #2
    Registered User
    Join Date
    09-14-2010
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Retaining Formatting when using (v)LOOKUP

    Here's some pictures for what I'm trying to do:

    This is the original sheet with the formatting:

    http://i54.tinypic.com/33uetdh.jpg

    This is the sheet I am using the vlookup on:

    http://i51.tinypic.com/6948qg.jpg

    Is there a way for me to conditionally format it so that if it says "Increased" / "Decreased" / whatever, that it will change the color of the two cells to the left of it? Or if one cell is larger than the other to change the color of all 3?

    Thanks!

  3. #3
    Registered User
    Join Date
    09-14-2010
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Retaining Formatting when using (v)LOOKUP

    Any ideas?

  4. #4
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,577

    Re: Retaining Formatting when using (v)LOOKUP

    Excel will not pull the formatting across with the VLOOKUP unfortunately. Someone in Excel Programming Folder might help you put together some VBA code to do that.
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1