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.