+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting - copy format of a cell

  1. #1
    Forum Contributor
    Join Date
    06-11-2016
    Location
    Atlanta
    MS-Off Ver
    2016
    Posts
    104

    Conditional Formatting - copy format of a cell

    I have a list of names in tab1 (in a pivot table based on tab2) that i have been color coding manually. On the second tab i have the same list of names in a data table. I want to copy the color formatting over to this tab.

    EX:
    Cell A1 contains "Matt" and I have highlighted it red, cell A2 contains "george" and it is highlighted green.
    I want every time "Matt" appears in the data table on tab2 to be red and every time "george" appears in the data table on tab2 to be green.

    Thanks in advance,

    Matt

    Edit:
    There are no dupilcates because they're full names (e.g. Plant, Bob Robert)
    Last edited by Buzz1126; 07-06-2017 at 11:17 AM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2404
    Posts
    24,758

    Re: Conditional Formatting - copy format of a cell

    CF cannot be used to say, "Make this cell's format look like that cell's format." This can be done with macros, although for an actual solution we need your file.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    06-11-2016
    Location
    Atlanta
    MS-Off Ver
    2016
    Posts
    104

    Re: Conditional Formatting - copy format of a cell

    I can write a VBA code real quick. It's not too important either.
    Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy/Paste/Format Paint For Conditional Formatting
    By kristopher_92 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-30-2015, 03:50 AM
  2. Replies: 2
    Last Post: 12-05-2014, 07:15 AM
  3. Cannot Format Cell with Conditional Formatting
    By lowprofile in forum Excel General
    Replies: 3
    Last Post: 06-03-2014, 02:36 PM
  4. [SOLVED] Conditional Formatting - If Cell A1=x format row 1
    By jjcgirl in forum Excel General
    Replies: 4
    Last Post: 03-27-2013, 07:46 PM
  5. How to copy cell format done by Conditional Formatting to Chart?
    By Excel4Everything in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-31-2013, 08:21 AM
  6. Replies: 2
    Last Post: 10-24-2011, 12:06 PM
  7. Copy>Special>Format: Not for Conditional Formatting?
    By Ingeniero1 in forum Excel General
    Replies: 2
    Last Post: 03-31-2006, 10:28 AM

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