Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy cells based on conditions in one workbook to another workbook | Excel Discussion (Misc queries) | |||
Copy cells based on conditions in one workbook to another workbook | Excel Worksheet Functions | |||
how to copy only values and formats of worksheets to new workbook | Excel Worksheet Functions | |||
Copy worksheet values and formats into another workbook | Excel Programming | |||
Copy a range of cells in an unopened workbook and paste it to the current workbook | Excel Programming |