I have a workbook with a data entry sheet, and then three other sheets displaying certain weekly statistics linked to the data entry sheet. There are times, though, when I need to delete a week's data, but that leaves me with a column of #REF , and it screws up the conditional formatting I've put in place. Is there some way to set it up so that I can delete a range of data from the entry sheet, and have the cells on the display sheet be automatically deleted as well, while having the conditional formatting be preserved? Or would it be possible to have the linked cells copy the formatting as well as the displayed value?