I have a spreadsheet with a number of workbooks, each work book is a school term timetable, beside each subject are 3 colomns, conditionally formatted. The original Spreadsheet is created elsewhere and I Con Form it then cut and paste it into its own worksheet in the main spreadsheet. I have a few workbooks already in the spreadsheet file name con formed the same way...
For some reason, now, when I cut and paste the worksheet with conditional formatting into the aforementioned spreadsheet, the conditional formatting doesn't come with it, and the option is grey'd out in the menu,not allowing me to re-CF the worksheet.....I have used the paste special etc etc.. . I have pasted it successfully into a new workbook with no problems at all, which seems to tell me that some protection has been added or something, but I know it hasn't (not deliberately anyway). how can I fix it or what do I check. It's really annoying me, cause Im sure it's soooo simple to fix.
Cheers Andrew