Conditional Formating

[PaulW]

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

 

[ewan7279]

Hi Paul,

Copy => Paste special => formats should do most if not all that you're
asking.

Ewan.