A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Links and Linking in Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Linking Background Cell Color

Thread Tools Display Modes
Old February 9th 13, 12:50 AM
TreeHugger1 TreeHugger1 is offline
Junior Member
First recorded activity by ExcelBanter: Jan 2013
Posts: 12
Default Linking Background Cell Color

I received some VBA code that will give a value to all the standard background colors for a cell. I then linked this formula to provide a number next to each cell on another worksheet within the spreadsheet (and then setup conditional formating on all of the cells next to the cell containing this formula). I have removed most of the content on the attached spreadsheet, since I don't need it spread over the internet. The basis of this design is becuase I have another person in my company that needs to extract only certain information from this spreadsheet, however, it is too complicated for them to figure out based on the spreadsheet that I use. I am trying to create a worksheet that my peer can open up and get the information that she needs (she needs to know that any certain cell is not completed by seeing that a cell is highlighted a color). You can find the code in Module #2 that references the background color of the cell. And click on the "Manage Rules" under the Conditional Formatting Tab on XYZ cell to see the formatting rules.

I need the background color to change on the XYZ worksheet without me actually modifying the formula on the ABC & XYZ worksheet. I have tried double clicking on a cell in worksheet ABC, but the cell on XYZ only seems to change color if I change the cell color on said ABC worksheet and then double click and hit enter on the XYZ worksheet (or actually modify the numbers within the cell on worksheet ABC). Is there any way to get this done without checking on the XYZ sheet or to create a formula that autoupdates by just changing the background color of a cell and not changing the actual formula within a cell?
Attached Files
File Type: zip Bid Breakdown - Other Clients.zip (20.4 KB, 242 views)

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
cell background color and cell text color Jeff Klein Excel Worksheet Functions 1 November 1st 07 08:59 PM
Add background color to cell Rich K. Excel Discussion (Misc queries) 2 January 23rd 07 09:56 PM
Cell background color (interior color) setting not working Martin E. Excel Programming 1 May 21st 06 07:00 PM
Default Border, Font Color, and Cell Background Color Elijah Excel Discussion (Misc queries) 1 October 28th 05 04:10 PM
Set background color of a cell in VBA Cindy Excel Programming 9 January 16th 04 09:05 PM

All times are GMT +1. The time now is 03:31 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.