+ Reply to Thread
Results 1 to 6 of 6

How to copy fill color from conditional formatting to another cell

  1. #1
    Registered User
    Join Date
    02-26-2014
    Location
    South Dakota
    MS-Off Ver
    Excel 2010
    Posts
    20

    How to copy fill color from conditional formatting to another cell

    I would like to copy the display color from a range (A1:D10 for example) that has 3 color scale conditional formatting over to another range (AA1:AD10). The second range (AA1:AD10) has unique values that I don't want to be replaced by the values from the first range (A1:D10). The ranges will be the same size.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,840

    Re: How to copy fill color from conditional formatting to another cell

    deleted...
    Last edited by protonLeah; 03-03-2022 at 02:40 PM.
    Ben Van Johnson

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,773

    Re: How to copy fill color from conditional formatting to another cell

    Can't you apply the same CF rules to that second range, making appropriate adjustments to the cell references?

    Hope this helps.

    Pete

  4. #4
    Registered User
    Join Date
    02-26-2014
    Location
    South Dakota
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: How to copy fill color from conditional formatting to another cell

    Wouldn't that just apply the CF rules to the data in that range?

  5. #5
    Registered User
    Join Date
    02-26-2014
    Location
    South Dakota
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: How to copy fill color from conditional formatting to another cell

    This example is what I want my worksheet to do: https://www.excelforum.com/excel-gen...ml#post5523886

    How can I change this to work to copy multiple columns? ex. Copy the CF from A1:D10 over to AA1:AD10?

  6. #6
    Registered User
    Join Date
    02-26-2014
    Location
    South Dakota
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: How to copy fill color from conditional formatting to another cell

    So this is what I ended up doing, and it works, but I'm sure there's got to be a cleaner way to enter the ranges. So the range who's conditional formatting colors I wanted to copy was BQ13:CK112, and the range I wanted to copy the color to was C13:W112.

    Please Login or Register  to view this content.

+ 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. [SOLVED] Fill Cell color without Conditional Formatting
    By cartica in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-19-2020, 04:37 PM
  2. [SOLVED] conditional formatting: fill cell color based upon =< or > =NOW()
    By InvGrp2 in forum Excel General
    Replies: 3
    Last Post: 01-16-2019, 06:53 PM
  3. Replies: 4
    Last Post: 12-31-2015, 04:32 AM
  4. Replies: 21
    Last Post: 12-16-2015, 03:04 PM
  5. Copy/paste based on fill color/conditional formatting
    By Wheelie686 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-27-2014, 03:45 PM
  6. Fill color of cells with conditional formatting for more than 3 criterias
    By Sai Prashanth in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-20-2014, 03:58 PM
  7. Cell Formatting Conditional On Other Cells Fill Color?
    By Kael_Sidhe@yahoo.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-06-2006, 12:25 PM

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