+ Reply to Thread
Results 1 to 5 of 5

Assigning a background color fill to a cell, given a background color fill on another cell

  1. #1
    Registered User
    Join Date
    09-19-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    20

    Exclamation Assigning a background color fill to a cell, given a background color fill on another cell

    As the text says:

    I have a cell that i want to color green, if another cell is MANUALLY colored green, theres no text on either cells so using standard text formulas doesnt apply, theres absolutely no text on any part of the spreadsheet. except for 2 headers.

    Is there some way to put on the conditional format something like this:

    Cell B1:
    =CellBackgroundColor(A1)

    Meaning the background color of B1 will be the same as what ever background color A1 has

    Or since this might not be possible to do, then how about this

    Is there any way to link the conditoinal formatting on 2 cells?

    Meaning WHAT EVER AND ANY conditional formatting is on A1, will be automatically applied to B1?

    this way if i change conditional formatting on 1 cell it will auto apply to awhole set of cells on multiple sheets without having to go to every sheet and every cell and change the formatting.

    Basically its the Conditional Formatting equivalent of doing B1=A1 on the cell, there has to be a way to do this....

    Can this be done?

    Any help will be apreciated.

  2. #2
    Registered User
    Join Date
    09-19-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    20

    Re: Assigning a background color fill to a cell, given a background color fill on another

    Bumpity Bump?

  3. #3
    Forum Contributor
    Join Date
    07-30-2014
    Location
    USA
    MS-Off Ver
    Version 14.4.3, Mac 2011
    Posts
    145

    Re: Assigning a background color fill to a cell, given a background color fill on another

    I think you are going to want to post this in the VBA part of the forums for something like this!
    Hope they answer you much quicker there! :D

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,055

    Re: Assigning a background color fill to a cell, given a background color fill on another

    I have a cell that i want to color green, if another cell is MANUALLY colored green,
    Not possible with regular formulas or Conditional Formatting - unless you have some logic that could be appluied to why the "other" cell was colored green. As suggested, you would need VBA for that.. If that is what you want, I can move this to teh VBA forum.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Registered User
    Join Date
    09-19-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    20

    Re: Assigning a background color fill to a cell, given a background color fill on another

    If the only way to do this is with VBA then yes please ! :D

+ 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]
    By XionicFire in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-02-2015, 01:17 AM
  2. Change cell background color based on another cells background color
    By Queo in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 06-10-2014, 05:28 AM
  3. Fill Color / Background change based on cell input
    By ganderson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-10-2009, 10:50 AM
  4. Macro to Change Cell Background Color From White to No Fill
    By emcdemc in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-06-2009, 08:55 PM
  5. [SOLVED] tab background fill - color
    By DeAnne in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 10-24-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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1