+ Reply to Thread
Results 1 to 10 of 10

IF(VLOOKUP) Formula That also Copies Cell Background Color to Target Cell

  1. 07-04-2014, 05:13 AM #1
    JRidge
    JRidge is offline
    Forum Contributor
    Join Date
    09-11-2013
    Location
    Germany
    MS-Off Ver
    Excel 2007
    Posts
    265

    IF(VLOOKUP) Formula That also Copies Cell Background Color to Target Cell

    Hi All,

    I am currently using this Formula to Search a table on sheet 2 (Tabelle2) and copy the date in the relevent cell (Cells) into the correct cell on Sheet 1 (Master Sheet).

    Please Login or Register  to view this content.
    Used in cells E10:AZ30 and E33:AZ46

    This works perfectly and is the formula behind all relevent cells in Sheet 1.

    I would like to keep this but to add that it also copies the background color of the cell in Sheet 2 to the cell in sheet 1.

    does anyone have any ideas if i can Bring this Formula into VBA and add the color changing part, It must only work on the cells listed above..

    Many thanks for any help received.

    Regards

    Jeremy
    Last edited by JRidge; 07-08-2014 at 08:30 AM.
    Reply With QuoteRegister To Reply
  2. 07-04-2014, 05:28 AM #2
    haripopuri
    haripopuri is offline
    Valued Forum Contributor
    Join Date
    11-02-2012
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    564

    Re: IF(VLOOKUP) Formula That also Copies Cell Background Color to Target Cell

    Formula cannot get the background colour, ok to use VBA?
    ________________________________________________________
    If your problem is solved, update the thread as SOLVED: Go to the top of the first post-Select Thread Tools-Select Mark thread as Solved OR - Go to the first post - Click edit- Click Advance- Just below the word "Title:" you will see a dropdown with the word No prefix.- Change to Solve- Click Save.

    Show your gratitude to the person who helped you solving your problem by clicking on star button at the bottom of such post.
    Reply With QuoteRegister To Reply
  3. 07-04-2014, 05:32 AM #3
    JRidge
    JRidge is offline
    Forum Contributor
    Join Date
    09-11-2013
    Location
    Germany
    MS-Off Ver
    Excel 2007
    Posts
    265

    Re: IF(VLOOKUP) Formula That also Copies Cell Background Color to Target Cell

    Hi haripopuri,

    VBA would be ok, but it need to work that when this formula adds the data to sheet 1 the Background color is also copied

    Is that possible?
    Reply With QuoteRegister To Reply
  4. 07-04-2014, 06:31 AM #4
    JRidge
    JRidge is offline
    Forum Contributor
    Join Date
    09-11-2013
    Location
    Germany
    MS-Off Ver
    Excel 2007
    Posts
    265

    Re: IF(VLOOKUP) Formula That also Copies Cell Background Color to Target Cell

    Hi All,

    I have had this moved from Formula Forum as i have been informed it is not possible with formula.

    Any help would be greatly appreciated.

    Regards

    Jeremy
    Reply With QuoteRegister To Reply
  5. 07-04-2014, 12:58 PM #5
    JRidge
    JRidge is offline
    Forum Contributor
    Join Date
    09-11-2013
    Location
    Germany
    MS-Off Ver
    Excel 2007
    Posts
    265

    Re: IF(VLOOKUP) Formula That also Copies Cell Background Color to Target Cell

    Any ideas?

    Thanks

    Jeremy
    Reply With QuoteRegister To Reply
  6. 07-04-2014, 03:52 PM #6
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: IF(VLOOKUP) Formula That also Copies Cell Background Color to Target Cell

    How was the cell background color assigned?
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
    Reply With QuoteRegister To Reply
  7. 07-04-2014, 06:27 PM #7
    JRidge
    JRidge is offline
    Forum Contributor
    Join Date
    09-11-2013
    Location
    Germany
    MS-Off Ver
    Excel 2007
    Posts
    265

    Re: IF(VLOOKUP) Formula That also Copies Cell Background Color to Target Cell

    You should know 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 07-08-2014, 04:13 AM #8
    JRidge
    JRidge is offline
    Forum Contributor
    Join Date
    09-11-2013
    Location
    Germany
    MS-Off Ver
    Excel 2007
    Posts
    265

    Re: IF(VLOOKUP) Formula That also Copies Cell Background Color to Target Cell

    Anyone got any ideas?

    Regards

    jeremy
    Reply With QuoteRegister To Reply
  9. 07-08-2014, 06:01 AM #9
    JRidge
    JRidge is offline
    Forum Contributor
    Join Date
    09-11-2013
    Location
    Germany
    MS-Off Ver
    Excel 2007
    Posts
    265

    Re: IF(VLOOKUP) Formula That also Copies Cell Background Color to Target Cell

    Ok, So far i have put this into vba and it works:

    Please Login or Register  to view this content.
    Any ideas how to also copy the background color of the cells?

    Regards

    Jeremy
    Reply With QuoteRegister To Reply
  10. 07-09-2014, 06:38 AM #10
    haripopuri
    haripopuri is offline
    Valued Forum Contributor
    Join Date
    11-02-2012
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    564

    Re: IF(VLOOKUP) Formula That also Copies Cell Background Color to Target Cell

    See this one. I use A1 notation and I made this one accordingly.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Change cell background color based on another cells background color
    By Queo in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 06-10-2014, 05:28 AM
  2. VBA That copies all condtional format background color and replicates actual color on cell
    By ckolawall in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2013, 03:36 AM
  3. system time stamp a cell when change in target cell. ( note target cell is formula ref)
    By R_VBA in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-22-2013, 11:38 AM
  4. Excel formula and cell background color?
    By ishialoshaun in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-18-2012, 06:00 AM
  5. formula based on cell background color
    By seyah in forum Excel General
    Replies: 2
    Last Post: 05-11-2007, 05:20 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1