Copy Cells formats to another workbook

  • Thread starter Thread starter koala
  • Start date Start date
K

koala

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
 
In the code that colors one, have it color the other.

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

would be an example of referencing the other workbook from the original
workbook.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional formatting 2
Referencing cell content and formatting 1
Cell values to an array, then array transpose to another workbook 8
Paste format without borders 3
Excel Highlighting duplicates 0
Copy cell value from one worksheet to matching worksheet in another workbook 4
Remove Hyperlinks Without Changing background shading 14
the value of a condition in a conditional format 2

Back
Top