When you say "copy fully" I take it your mean a simple CTRL C & CTRL P. That makes no difference, the conditional formatiing fomulas do not update. I'll try the formula you suggest instead.