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.
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.