Filter By Color In Excel. Click on the filter arrow in the make column and you ll see lots of options. Enter yes in the first box and then select light red fill with dark red text from the second box.
Select the column that you want to filter by cell color and click data filter see screenshot. In excel there is no direct way for you to filter rows by multiple colors but you can create a vba code to return the color index number of the corresponding row in a new column and then filter the rows by this helper column. Enter the formula getcellcolor f2 in cell 2 of the newly added filter by color column.
Click the downwards pointing arrow next to the column that contains data you want to filter.
In a range of cells or a table column click a cell that contains the cell color font color or icon that you want to filter by. In a range of cells or a table column click a cell that contains the cell color font color or icon that you want to filter by. Select the data you want to filter by. On the data tab click filter.
