+ Reply to Thread
Results 1 to 7 of 7

How to fill color cells based on another cell's fill color?

  1. #1
    Forum Contributor
    Join Date
    03-04-2015
    Location
    Jakarta
    MS-Off Ver
    15
    Posts
    154

    Post How to fill color cells based on another cell's fill color?

    I want to fill color cells 2 to 10 automatically if cell 1 get fill color. Please, help me how to apply it from conditional formatting.

  2. #2
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: How to fill color cells based on another cell's fill color?

    Assuming cell 1 is conditionally formatted, apply the same rule to the other cells.

  3. #3
    Forum Contributor
    Join Date
    03-04-2015
    Location
    Jakarta
    MS-Off Ver
    15
    Posts
    154

    Re: How to fill color cells based on another cell's fill color?

    @ jason.b75
    show me the steps, please

  4. #4
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: How to fill color cells based on another cell's fill color?

    Go to conditional formatting manager, select your existing rule and change the 'Applies to' range so that includes all of the cells.

  5. #5
    Forum Contributor
    Join Date
    03-04-2015
    Location
    Jakarta
    MS-Off Ver
    15
    Posts
    154

    Re: How to fill color cells based on another cell's fill color?

    in my problem is, i will fill color row 1 manually, if the color change so the row 2 to 10 will change automatically. And if the fill color on cell 1 is cleared, the cells 2 to 10 cleared automatically.

  6. #6
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: How to fill color cells based on another cell's fill color?

    In which case you will not be able to automate the process.

    Conditional formatting will not be able to detect the fill colour of the cell, or when the fill colour is changed.

    Vba will be able to identify the fill colour, but not when it is changed, so there is no way to do that automatically either.

  7. #7
    Forum Contributor
    Join Date
    03-04-2015
    Location
    Jakarta
    MS-Off Ver
    15
    Posts
    154

    Re: How to fill color cells based on another cell's fill color?

    thank you very much for the explanation

+ 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] Change a cells fill color. VBA to make another cell the same color and also changes.
    By PeteABC123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-23-2016, 12:34 PM
  2. Macro to change cell text color based on darkness of cell fill color
    By cincyshirm61 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-25-2014, 12:11 PM
  3. [SOLVED] change fill color of a range of cells based on color of a cell?
    By DarMelNel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2014, 04:48 PM
  4. How to color-fill blank cells, then once data is entered cell is no-fill
    By hatemail13 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-28-2013, 07:57 PM
  5. [SOLVED]Fill Color (highlight cells) but not to print fill color
    By itszille in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-24-2012, 05:37 PM
  6. How do i auto fill cell color based on other cells' color?
    By Kchatza in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-22-2012, 05:00 AM
  7. Replies: 3
    Last Post: 07-08-2010, 06:48 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