Printing or Copying Just Coloured Cells

[AlanWade]

I am using conditional formatting to find certain types of data and then change the colour of the cell background/text. Is there a way to either print just them cells or send the data in them to another sheet please?

Thanks in anticipation

Alan

 

[AlanWade]

or maybe someone knows if there is an IF statement related to the cell colour I could use to get the data in one place and then I could print out from there.

 

[AlanWade]

Anyone know if it can be done?