Copy Cells formats to another workbook
 

Hello Forum,

I have a master workbook with numerous sheets. On one of these sheets
“allocations”, there is code that colours the background of the cells
depending on set criteria.

On another workbook “daily cycle”, there is sheet “individual”, that
links to some cells in “allocations”.

Is it possible to have code that will also colour the appropriate
background cells in the sheet “individual”.

Currently only the values update, not the formats etc.

The cells are coloured depending on code, not conditional formatting.

Thanks in advance

Koala


--
koala
------------------------------------------------------------------------
koala's Profile: http://www.excelforum.com/member.php...o&userid=12953
View this thread: http://www.excelforum.com/showthread...hreadid=278244

Copy Cells formats to another workbook
 

In the code that colors one, have it color the other.

workbooks("Daily Cycle.xls").worksheets("Individual").Range("A1").C olorIndex
= 13

would be an example of referencing the other workbook from the original
workbook.

--
Regards,
Tom Ogilvy

"koala" wrote in message
...

Hello Forum,

I have a master workbook with numerous sheets. On one of these sheets
"allocations", there is code that colours the background of the cells
depending on set criteria.

On another workbook "daily cycle", there is sheet "individual", that
links to some cells in "allocations".

Is it possible to have code that will also colour the appropriate
background cells in the sheet "individual".

Currently only the values update, not the formats etc.

The cells are coloured depending on code, not conditional formatting.

Thanks in advance

Koala


--
koala
------------------------------------------------------------------------
koala's Profile:
http://www.excelforum.com/member.php...o&userid=12953
View this thread: http://www.excelforum.com/showthread...hreadid=278244