Excel 2007 : Conditional Formatting - Select Data

Hi,

Firsty time posting so please help me if you can.

I have setup a conditional formatting rule on a selection of cells to highlight the conditional cells in "green" - cells are across 28 columns and 500 rows.

Is there any way i can only select the cells which are green ( Meet the conditional formatting criteria) and paste the values into another spreadsheet ?? - that way removing all the values / or leaving blank the values i am not interested in.

Many Thanks in advance

Had a look around and already found some examples for you
http://www.mrexcel.com/forum/showthread.php?t=16214