FDibbins,

Thank you for your reply, however, the countif and sumif (from what I can see) will provide a numeric value to how many rows meet the condition. I am looking to copy certain cells from those rows to another worksheet based on the color of a cell.

Thanks, Jeff