In Excel 2007/2010, it is very easy to filter rows by Cell Color. In Excel 2007/2010 we have inbuilt functionality to do so. There can be two way to do this Filter by Color.
Follow the below Steps to Filter by Cell Color in Excel 2007/2010:
1. Select the Range where you want to apply the Filter.
2. Press Ctrl + T (To create Data Table of the Selected Range)
- Color Filter will be enabled even if we DO NOT create a Data Table by Selecting that particular Range. Creating Data Table will format your data properly. You can do this filtering even by going to Data Tab–> Filter–> Filter By Cell–> Select the Color
- If you want to add a Header to your selected range then Check the Check-Box otherwise it will consider the first row as header Name.
3. Table is created and auto-formatted like a table as shown below.
4. Click on Filter Arrow on the Column Header which you want to filter by Cell Color.
5. Select option as Filter by Color and then Select that Particular by Which you want to filter.
6. In the Above example, I had selected Filter Color as Red, so all the other color Rows got filtered and only rows with Red Color are shown.