Conditional Formatting but not copying it as such

[Aidan]

I have two sheets

Sheet 2 has 12 months of data in it - Jan to Dec. The cells in this are conditionally formatted with a percentage tolerance from the previous month.

Sheet 1 I want to isolate one months data in it so for example Mar and I want it to copy all the March data from sheet 2 which it does but not the colours in the conditional formatting. For example on the income side if income is greater than the previous month plus 5% it goes green and if less than the previous month by 5% it goes red. When it copies to sheet 1 the cell background is white.

Is there a way to do this?

 

[t0ny84]

If you select the text you want to copy and then right click where you want to past the data and select PASTE VALUES then right click again and select PASTE FORMATTING.
This should copy everything except the Conditional Formatting.

t0ny84