Copying cells to new workbook based on cell background....

[stusolly]

Hello All,

I have been working away on this problem for several hours and can't seem to get my code to work. I thought someone here might be able to solve it pretty quickly.

I have a workbook (column A:M) which uses conditional formatting for row M. The conditional formatting is different for all of the rows (there are currently over 100, and more might be added). I need to get a macro that will copy all cell values in the row from A:L to a new workbook when the value of M is colored red or yellow.

I was also wondering if it is possible to automatically name the new workbook based on the date.

Thanks for all your help!

Stu

[StephenR]

Rather than use the colour, you use the criteria which form the basis of the CF. Post a workbook if you want specific help.