F Fred Smith Mar 3, 2004 #1 In an Autofilter, is it possible to select the cells which have a specific background color (say, yellow)?
In an Autofilter, is it possible to select the cells which have a specific background color (say, yellow)?
G Gord Dibben Mar 3, 2004 #2 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
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
