Can search by cell format like fill color?

[T-Diego]

Can cells be selected from a series of spread sheets by only the cell's fill
color so that all such entries can then be transferred to a single new sheet?

 

[Bob Phillips]

Ron de Bruin's EasyFilter add-in probably does all that
http://www.rondebruin.nl/easyfilter.htm

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

Can cells be selected from a series of spread sheets by only the cell's fill
color so that all such entries can then be transferred to a single new

sheet?