Welcome to the forum.

This sounds very frustrating so hopefully we'll be able to help you.

What is your conditional formatting formula?
When you copy and paste the values from the report into your worksheet, do the cells show a green triangle in the top right of the cell?