I have a spreadsheet that i need to exactly copy to another worksheet so that
i can conditionally format the copy to highlight what i need. By doing this i
can replace the original data weekly without changing or setting up the
conditional format each week.

I have two problems: -

1. How can i copy the information across so that if there is no data to copy
it will show a blank in the cell
2. Is there a way to then show in a third workbook only the rows with
conditionally formatted data within them?

Thanks