Problems with Conditional Formatting when creating duplicate sheets from Sheet 1

[beaujolais44]

I have made a staff Roster. Sheet 1 is all finished for January with some merged cells, conditional formatting etc. I now want to duplicate this sheet to make sheets for February through to December and then just make the small changes in each sheet relative to that particular month. However, it seems that when I create the new sheet (create a copy), the conditional formatting goes haywire and I can not see why. Is there a special way to do what I want? Any help will be much appreciated.

[:) Sixthsense :)]

Strange, but I am sure the CF should be there in the duplicated sheet.

[FDibbins]

CF in 2007 does not like to be copied, for some reason. I have had the same problem, the CF rules double, triple and sometimes even quadruple up when you copy cells

Maybe try just creating a new blank sheet, then on sheet1, click in the very top left corner (the little triangle) to select all, then copy CTRL C, select A1 on the new sheet, and paste CTRL V

[beaujolais44]

Thanks for your reply. I actually stopped that particular task, carried on with some other things and then tried again and this time it worked!!! I am at a loss to know why as I changed nothing. I am however, reluctant to put it down to finger trouble. Anyway, as it was no longer necessary, I did not try your suggestion. Thanks for your reply though, I will bear that method in mind for the future.

[DaveDeV]

One other thing you can try...

Conditional Formatting defaults any cell references to absolute references and older versions may just include the worksheet name in the pasted CF.

Edit the formulae in the source worksheet's CFs to remove the "$" from all cell references then try again to copy/paste-special formats.

Apologies but I can't replicate the problem so can't test it here (2010 only)

Dave

[FDibbins]

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.