Help with conditional formatting:colour code

I would be extremely grateful for some help with this problem. Thanking you in advance.

I have a table with conditional formatting applied. This table uses data from elsewhere within the same sheet to colour code my cells.

How can I copy and paste this table to another workbook? Each time I try I lose the colours as they are dependent on the data in the other sheet. This data is continuosly updated so I want to make a record of this without having to manually colour each cell.

Originally Posted by Vipulparbat

I would be extremely grateful for some help with this problem. Thanking you in advance.

I have a table with conditional formatting applied. This table uses data from elsewhere within the same sheet to colour code my cells.

How can I copy and paste this table to another workbook? Each time I try I lose the colours as they are dependent on the data in the other sheet. This data is continuosly updated so I want to make a record of this without having to manually colour each cell.

Hi Vipulparbat,

Am I understanding correctly?
If the "table" and the "data" are in the same workbook,why not just make another copy of the workbook - i.e. "Mycopy", then you will retain all of the formatting.

oldchippy