Google Sheets: Sort and Filter Cells by Text or Fill Color

Google has introduced two additional parameters in Google Sheets-Text Color and Fill (Background) Color to filter and sort cells. These filters, together with the classification by values and conditions, making it easier and faster to find and surface relevant data in Sheets. This feature is available on both the mobile and on the web. This function will standardly be available.

Select Filter by Color and choose “Fill color” or “Text color” to use this feature in Google Sheets. At the top of the range, it will show matching cells.


This launch starts with March 23rd, 2020.


Join Our Weekly Newsletter

Enter your email address below to subscribe to our newsletter