How to get a BG colour from cell in Workbook1

Microsoft Office excel 2007 home & stude...
July 30, 2010 at 05:51:46
Specs: Windows XP
Hi, I tried so hard looking on the internet but with no luck. I want a cell to show a value from another cell in another file, and that this cell also have the same background colour as the source. Is it possible to do this without using VBA script? If not, what can I do to make it easy? Thanks!

See More: How to get a BG colour from cell in Workbook1

Report •


#1
July 30, 2010 at 06:15:54
How is the color set in the source workbook?

Can you use Conditional Formatting in the destination workbook to set the fill color?


Report •

#2
July 30, 2010 at 07:14:37
Hi DerbyDad

I tried to use conditional formatting, but cannot find an appropriate condition, that basically would be: if cell A2 in Workbook2 is green, this A2 cell in Workbook1 should be of the same colour (green). The only two colours used are nofill and green.
Here is how the system works.
I have a workbook, say Workbook1, where I manually update the cells with percentage. Also, when I send these data to a client, I colour the cells in green (manually).
In another workbook, say Workbook2, I need to import the data I fill in Workbook1 to make some calculations (sums, percentage). I also want to know in Workbook2 which data are sent, hence the cells should have the same colour as Workbook1.
Example:
In Workbook1 I enter in A2 the data 100%.
In Workbook2 I enter A2='Workbook1!Sheet1'!A2
Then after a couple of days I need to colour this cell in green in Workbook1, and I want that when I open Workbook2, A2 is also green.
Is it clearer now...? Thank you for your attention and please tell me if I need to explain further.


Report •

#3
July 30, 2010 at 07:35:06
Since it appears that the fill color is set "manually" and not based on any condition, I don't think you will be able to do it without VBA.

AFAIK, you'll need VBA to check/set the fill color of the source/destination cell.


Report •

Related Solutions

#4
July 30, 2010 at 07:57:23
AAAhhhh!! I just had an idea!!
I can create a new column and set a value there, say for example "1" if the cell is to be coloured in green.
In this way, I can get that value in another workbook and set the same conditional formatting!
Sorry to ask a question and answering by myself, I was hoping to find a formula to do that, but also a simple flag in B2 will do!
Thank you all the same :)

Report •

#5
July 30, 2010 at 08:12:34
Sometimes the answer can be found just by talking out the problem.

That works in relationships as well as Excel ;-)


Report •

#6
July 30, 2010 at 08:25:55
How true is that!!
Thanks! :)

Report •


Ask Question