I have about 15 sheets in a workbook. Each sheet contains large volumes of data. Some of the rows are conditionally colored yellow based on the certain criteria of a cell in each row. I need a short macro that will copy all the yellow colored rows in each of the 15 sheets into a single sheet.

Plainly put, I don't know how to use an AutoFilter function to search for criteria based on color rather than text

TIA

CJ