Keep conditional formatting when selection is saved to a new file

Hi all,

I'm currently working on a file which keeps track of a top 40-chartlist.
In cells E2-E41 I have the 40 hits of a particular week.
Through conditional formatting i've been able to highlight the new entries of that week
(yellow background, red cellcolour and bold font)
I've got a macro which saves my selection E2-E41 as a separate file.
The problem is that I want it to be saved with the conditional formatting mentioned above.
(Now my selection is saved with the default cell formatting)

Here's my code so far:

Please Login or Register  to view this content.

I bet it's only one or two lines of extra code, but can't figure out what :S
Hope someone can help me out with this one

Thanx in advance

Hello MrtinkerTrain,

Welcome to the Forum!

There are 2 options you can use.

Please Login or Register  to view this content.

Or if you don't need to restrict what is pasted...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Thanx for your reply, Leith

I will give both of them a try and will give feedback of my results

Happy Easter by the way