How to filter by color in Google Sheets | Scribe

    How to filter by color in Google Sheets

    information ordinal icon
    This Scribe shows you how to filter a column by cell color
    1
    Make sure you have a data filter applied. Click the filter icon next in the first cell of the appropriate column header to open up the filter options
    2
    Hover or click "Filter by color" Hover or click "Fill Color" and select the color you want to filter by. Note, this also works for "Text Color" (just select that if you want to filter by text color instead of cell color)
    3
    You'll see your data set filtered by your selected color!