+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Changing cell color based on multiple cell colors from other sheets

  1. #1
    Registered User
    Join Date
    01-26-2012
    Location
    CT, USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Changing cell color based on multiple cell colors from other sheets

    Hi all, new here. Lurked a couple times but didn't register until now when I've really been stumped. Don't even know where to begin with this one.

    Have a 4 worksheet 2007 excel file. Each worksheet has a table showing building status of all the rooms in a multistory building. It's a building status document. Basically worksheet 1,2,3 contain an individual room building status indicated by color. Worksheet 4 is an overall status tab. Colors are manually entered on worksheets 1 through 3. The 4th worksheet is supposed to change color of cell automatically based on if the cell is blue on all of the other worksheets. What I need to happen: If cell in worksheets 1,2,3 = blue, I need worksheet 4's corresponding cell = blue automatically.

    Change worksheet example.jpg

    complete worksheet example.jpg

    Excel 2007. Tried to use Conditional formatting and honestly don't know if it has options to do this based off color not value and have no experience with it. I've tried looking into vb code but every example I find doesn't come close enough to this scenario for me to change it for my needs. (with my limited knowledge)

    Any advice?
    Last edited by schiddy; 01-26-2012 at 03:04 PM.

  2. #2
    Registered User
    Join Date
    01-26-2012
    Location
    CT, USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Changing cell color based on multiple cell colors from other sheets

    Bump. Anyone?

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

    Re: Changing cell color based on multiple cell colors from other sheets

    I have tried to use CF based on colors as well, but not had any success either. the "code" function only works with text

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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