+ Reply to Thread
Results 1 to 2 of 2

Copying Color of One Cell to a Corresponding Range of Cells

  1. #1
    Registered User
    Join Date
    01-02-2013
    Location
    Chicago, Illinois
    MS-Off Ver
    Excel 2010
    Posts
    25

    Copying Color of One Cell to a Corresponding Range of Cells

    Hey all,

    I want to take a color of cell and use that color to fill a range of corresponding cells in the same row as the cell fill color. I have already done conditional formatting to get a list of cells to be a bunch of different filled colors, but I'd now like to take each color and extend it to the rest of the table and highlight each line with the corresponding color.

    I've done some googling but can't seem to find anyone else with the same exact problem.

    Example:

    E4:E77 is my list of already color coordinated items, and they are mixed around and there are duplicates, etc. I want to take those colors and "paste" them onto the corresponding rows in the remaining cells of the table, values F4:M77. If I try to use format painter, it does not work and instead ruins all formatting for the numbers and gives the wrong coloring.

    It's probably very easy (and it should be) and I'm doing it in an overly-complicated way, but I can't figure out how to do it.

    Thank you for any help!

  2. #2
    Registered User
    Join Date
    01-02-2013
    Location
    Chicago, Illinois
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Copying Color of One Cell to a Corresponding Range of Cells

    Does anyone have any suggestions?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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