I have looked at a list of options available when copying an entire sheet (in my case, I will be saving it to a brand new file without Macros enabled).
What I would like to do is use some conditional formatting in the original file to trigger the end user to check data where necessary... BUT it's absolutely vital that formatting doesn't get copied into the final file.
Is there a way to NOT copy the conditional formatting? Or some other way to exclude it from the final file?
Debbie
Bookmarks