How To Filter By Color In Google Sheets

When yous accept a big sail full of data, using the Google Sheets filter and sort features can assist you find what you lot need. If y'all utilize color to make information pop, you can filter or sort using that color.

Information technology doesn't matter if yous've added colour manually or set up a provisional formatting rule. Y'all can use both the filter and sort features based on the colors in your sail. What's fifty-fifty better is that you can use the fill color for a cell or font colour for text.

Filter past Color in Google Sheets

If you desire to filter information, meaning but see data that meets your colour criteria, start by selecting the cells.

RELATED: How to Filter in Google Sheets

Go Data > Create a Filter in the menu or click the Create a Filter push in the toolbar.

Create a filter in Google Sheets

This places a filter button in your column header. Click that button to apply the filter.

Filter button in a column header

Movement your cursor to Filter past Color. In the popular-out bill of fare, get to Make full Color or Text Color and choose the colour. You lot'll only run into the colors used in your sheet equally available options.

Filter by color options in Google Sheets

You lot'll and so see your data update to only prove those cells containing either the fill or text color yous select.

Filtered by color

When y'all finish, you tin choose a different filter option using the button in the header. Alternatively, turn off the filter by selecting Information > Remove Filter in the card or past clicking the Remove Filter button in the toolbar.

Remove a filter

Sort by Colour in Google Sheets

Maybe y'all don't want to filter out data just see information technology all simply sorted. You can sort data by color using the Filter tool besides.

RELATED: How to Sort in Google Sheets

Before you add together a filter, be sure to select all the data that y'all want to sort. For instance, if you have two columns as in our example, you'll want to select them both. If you merely select the one column containing colors, the sort only applies to that column. This causes a mismatch of the data.

Employ a filter as described above to display the filter buttons in the column headers.

Create a filter to sort by color

Click the push for the column you want to sort by and motion your cursor to Sort by Color. Get to Fill up Color or Text Color in the pop-out carte and then choice the color. Again, simply the colors used in your sheet are available options.

Sort by color options

You'll see your data update and sorted past the column and colour yous chose.

Sorted by color

When you cease, remove the filter equally explained above. You can choose Data > Remove Filter in the menu or the Remove Filter button in the toolbar. Go along in mind that your data remains sorted this manner unless you sort it again.

Colors are useful for more than than making data stand out in your spreadsheet. You can use those colors to filter or sort your information as needed. For more, take a look at how to apply a color scale based on value in Google Sheets.