Filter based on formatting

  • Thread starter Thread starter Fred Smith
  • Start date Start date
F

Fred Smith

In an Autofilter, is it possible to select the cells which have a specific
background color (say, yellow)?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formula formatting 2
Cond. formatting, based on other cell values? 3
Conditional Formating based on Date 5
Format cell color? 5
formatting comment's background color 1
Autofilter to filter out non-numeric rows 3
Check to see if Autofilter is Engaged 7
AUtofiltering dates 1

Back
Top