Hi all. I have found a really useful sheet that builds a gantt chart using conditional formatting. I would like to use it by copying the chart into a worksheet I am using to track my project logistics. Unfortunately whenever I do that all the conditional formatting is lost. Is there any quick way to copy cells and maintain their conditional formatting?

Thanks in advance, Mike