I am in UK and frequently use more than one template created by our US head office. I need to copy these templates into already exisiting customer files created by myself and then input formulas / data into some of the columns, but when i copy some of these sheets over to the the other files the background fill changes from the original colour that i need to use as per company colour scheme to an alternative colour.
I have worked out that when i look at the standard fill colours on the US created file and compare this to the ones on my version of excel some are in different places but most are custom colours, this means i have to highlight all of the cells and then change the Red, Green and Blue in the more colours screen to match what has been created.
Is there a way around this when i copy and paste this document to the existing file as i waste an hour or so every day doing this.
I am not able to edit their file as they also use this in the US and also frequently update the file to add new item numbers and change pricing etc...
Bookmarks