copying data without existing format

JRS

New Member
Joined
Mar 10, 2011
Messages
44
I have a spreadsheet with some conditional formatting set up. I frequently recieve new data to add to my spreadsheet, but due to the formatting on the incoming data spreadsheet, when I copy and paste the data into my own spreadsheet, my conditional formatting doesnt seem to take.

Any Ideas if there is a way of copying data across and ignoring old formatting (such as cell colour). OR getting my conditional formatting to overwrite any of the incoming data's formatting???

Thanks.
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Watch MrExcel Video

Forum statistics

Threads
1,109,331
Messages
5,528,053
Members
409,800
Latest member
camronmartin

This Week's Hot Topics

Top