Filter By Cell Color

Filtering cells by color in Excel has been very helpful in choosing all the cells that are same colored and required data.

 

To filter using colors: 

• Select a range of cells containing formatted by cell color, font color, or an icon set.
• On the Data tab, in the Sort & Filter group, click Filter.
• Click the arrow  in the column header.
• Select Filter by Color and then, depending on the type of format, select Filter by Cell Color, Filter by Font Color, or Filter by Cell Icon.
• Depending on the type of format, select a color, font color, or cell icon.
• To reapply a filter after you change the data, click a cell in the range or table and then, on the Data tab, in the Sort & Filter group, click Reapply.

Posted in: filter by cell color,Filter By color,Microsoft Excel 2007,Microsoft Office Support,PC Support,Technical Support,TechSupp247