We can filter the data by cell background color or by font color in Excel.
Let’s say we have below given data set.
![Data Set for Filter by color](https://www.pk-anexcelexpert.com/wp-content/uploads/SortAndFilter/Sort-and-Filter-13.jpg)
Now we have to filter the dates wherein cells background color is yellow.
- Select the entire range and put the filter (Press Shift+Ctrl+L)
- Open the drop down and go to the filter by color option.
- Go to the Filter by Cell Color and click on yellow color.
![Filter by cell background color](https://www.pk-anexcelexpert.com/wp-content/uploads/SortAndFilter/Sort-and-Filter-14.jpg)
- Click on OK Button.
- Data will be filtered by yellow color
![Filtered Data](https://www.pk-anexcelexpert.com/wp-content/uploads/SortAndFilter/Sort-and-Filter-15.jpg)
We also can filter the data by font color
- Select the entire range and put the filter (Press Shift+Ctrl+L)
- Open the drop down and go to the filter by color option.
- Go to the Filter by Font Color and click on red color.
![Filter by Font color](https://www.pk-anexcelexpert.com/wp-content/uploads/SortAndFilter/Sort-and-Filter-16.jpg)
- Click on OK Button.
- Data will be filtered by red font color
![Filtered Data](https://www.pk-anexcelexpert.com/wp-content/uploads/SortAndFilter/Sort-and-Filter-17.jpg)