Filter based on formatting

F

Fred Smith

In an Autofilter, is it possible to select the cells which have a specific
background color (say, yellow)?
 
G

Gord Dibben

Fred

Not without some VBA Function help.

See Chip Pearson's pages on colors.

http://www.cpearson.com/excel/colors.htm

Using a helper column and Chip's CellColorIndex Function you could then
Autofilter on Color Index number returned by a formula in the helper column.

Gord Dibben Excel MVP
 
Top