Conditional formatting not copying properly to separate sheets

[Keegan1116]

Hi there,

I've created a spreadsheet that includes an active checklist for each of my projects on the go. in any given row is the item, a blank cell for date of completion to be entered, and beside that is a cell that will output specific text based on what needs to be completed, and will highlight the cell red if something needs to be done. Example:

Purchase Order: Requested: 18-Feb Received: (Enter Date) "Action Required"
(In this scenario, the cell beside "Received" would be highlighted red, as would the "Action Required" cell.

My problem I'm having is that when I copy & paste the checklist template across worksheets, the conditional formatting is all messed up. Some of them I need to just go into "Manage Rules", click on each of them and click "Apply", meaning they are working but not activated for some reason?

Other cells will not work at all, meaning they won't highlight red at all. They instead reference (in the rule formula) the worksheet that the template came from, meaning I have to change them every single time.

Because I'm going to be having other people use this workbook, I need every thing to be automated and without error. It's an easy fix for myself but someone else would not know how to fix these individually. Any one have any idea on how to prevent this from happening when I copy and paste conditional formatting into separate worksheets?

Note: I am not using A$1$ or anything like that, so I know that isn't the issue.

[FDibbins]

CF does not like to be copied across sheets. Try checking to see if there is any sheet reference in the CF rule, if so, remove it if possible.

[Keegan1116]

I actually found a solution but I'm not sure why it works. I copied the range (A2:W73) instead of rows (A-W). This allowed the CF to reference the new sheets cells as opposed to the original sheets cells. Odd