When you have a large sheet full of data, using Google Sheets' filter and sorting features can help you find what you need. If you use color to make the data appear, you can filter or sort using that color.
It doesn't matter if you've added color manually or defined a conditional formatting rule. You can also use the filter and sort features based on colors in your sheet.
See also: How to update Google Play Store?
See also: Gmail UI change: Google explains how it works
Filtering by color in Google Sheets
If you want to filter data, that is, see only data that meets your color criteria, start by selecting the cells.
Go to Data > Create a Filter in the menu or click the Create a Filter button in the toolbar.
This places a filter button in your column header. Click this button to apply the filter.
Move the cursor to Filter by Color. In the pop-up menu, go to Fill Color or Text Color and select the color. You will only see the colors used in your sheet as available options.
You will then see your data update to only display those cells that contain either the fill or text color you selected.
When you're done, you can select a different filter option using the button in the header. Alternatively, turn off the filter by choosing Data > Remove Filter from the menu or by clicking the Remove Filter button in the toolbar.
Sort by color in Google Sheets
Maybe you don't want to filter data, but just see it all sorted. You can also sort data by color using the Filter tool.
Before adding a filter, make sure to select all the data you want to sort. For example, if you have two columns like in our example, you'll want to select both of them. If you select only the one column that contains colors, the sort will only apply to that column. This will cause data to be inconsistent.
See also: How to delete your Google Voice number
Apply a filter as described above to display the filter buttons in the column headers.
Click the button for the column you want to sort by and move the cursor to the Sort by Color option. Go to Fill Color or Text Color in the pop-up menu, then choose a color. Again, only the colors used in your sheet are available options.
You will see your data update and sort based on the column and color you selected.
When you're done, remove the filter as explained above. You can choose Data > Remove Filter from the menu or the Remove Filter button on the toolbar. Note that your data remains sorted this way unless you sort it again.
Colors are useful for more than just making data stand out in your spreadsheet. You can use these colors to filter or sort your data as needed.
Information source: howtogeek.com
