+ Reply to Thread
Results 1 to 7 of 7

Match value, take value 1's background/font color and put it in value 2's entire range

  1. 04-26-2017, 05:51 PM #1
    AnirudhC
    AnirudhC is offline
    Registered User
    Join Date
    03-02-2017
    Location
    India
    MS-Off Ver
    2016
    Posts
    24

    Match value, take value 1's background/font color and put it in value 2's entire range

    The range is dynamic on both the sheets.

    Sheet "Source" and sheet "Final" have names of different kids, whatever background color and font color there is in "Source" I want it to match the name and put it in the sheet "Final"...

    So for example if name "X" is there in "Source" I want it to find the same named kid in "Final" and fill the entire row till column G with the same background color and font color.

    Also the name can occur twice or thrice in the "Final" sheet..

    Thanks in advance!
    Attached Files Attached Files
    Last edited by AnirudhC; 04-28-2017 at 01:29 PM.
    Reply With QuoteRegister To Reply
  2. 04-26-2017, 06:52 PM #2
    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: Match value, take value 1's background/font color and put it in value 2's entire range

    Try this and let me know:

    Please Login or Register  to view this content.
    Last edited by xladept; 04-26-2017 at 07:11 PM.
    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
  3. 04-27-2017, 09:46 AM #3
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Match value, take value 1's background/font color and put it in value 2's entire range

    Maybe:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 04-27-2017, 10:19 AM #4
    AnirudhC
    AnirudhC is offline
    Registered User
    Join Date
    03-02-2017
    Location
    India
    MS-Off Ver
    2016
    Posts
    24

    Re: Match value, take value 1's background/font color and put it in value 2's entire range

    Thanks for the reply, It is picking yellow color fine, however green is olive green and the font color is light red?
    Reply With QuoteRegister To Reply
  5. 04-27-2017, 10:22 AM #5
    AnirudhC
    AnirudhC is offline
    Registered User
    Join Date
    03-02-2017
    Location
    India
    MS-Off Ver
    2016
    Posts
    24

    Re: Match value, take value 1's background/font color and put it in value 2's entire range

    Hi John, thanks for the reply,

    You're macro is picking perfect color wise, however last 4 names it is not picking at all?
    Untitled.jpg
    Reply With QuoteRegister To Reply
  6. 04-27-2017, 11:45 AM #6
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Match value, take value 1's background/font color and put it in value 2's entire range

    Revised:

    Please Login or Register  to view this content.
    Last edited by JOHN H. DAVIS; 04-27-2017 at 12:05 PM.
    Reply With QuoteRegister To Reply
  7. 04-27-2017, 10:14 PM #7
    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: Match value, take value 1's background/font color and put it in value 2's entire range

    Using John's idea:

    Please Login or Register  to view this content.
    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. [SOLVED] Reference - No only value but also font color and background color
    By douglascaixeta in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-12-2014, 01:25 PM
  2. [SOLVED] Conditional formatting to adapt font color to background color
    By jankee in forum Excel General
    Replies: 4
    Last Post: 08-23-2013, 09:38 AM
  3. VBA Module counts background color, would like it to count font color
    By LawBeforeGrace in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2013, 08:11 AM
  4. [SOLVED] Row font color to Match color of font in column D cells that will change IN DROP DOWN BOX.
    By NicksDad in forum Excel General
    Replies: 2
    Last Post: 02-04-2013, 02:00 PM
  5. how can I conditionally change font color, or background color?
    By MOHA in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-21-2006, 01:57 PM
  6. Default Border, Font Color, and Cell Background Color
    By Elijah in forum Excel General
    Replies: 1
    Last Post: 10-28-2005, 12:05 PM
  7. Excel 2003 Font Color and Background Color
    By DrankPA6 in forum Excel General
    Replies: 1
    Last Post: 08-12-2005, 07:05 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