Hi,

Does anyone know how to select a range of rows/column while they were tagged
by Fill Color?
For example,
A1 to A3, and A10 to A15 have Fill Color Green
A4 to A6, and A7 to A9 have Fill Color Red
Then, I want to filter/select only the Red and paste the values in a
different workbook.

Is there any work-around to do these or a VBA script available that somebody
can share?

Thanks in advance.

-Wilfredo