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?
Bookmarks