Filtering By Color in Google Sheets!
9While Excel is typically considered to be the better of the two programs, Sheets can handle its fair share of spreadsheet management, all without costing users a dime. Unfortunately, the ability to filter by color is one feature that Google Sheets just can’t match—at least, not yet anyway. While Sheets might not have this feature built in, there are a few ways you can filter by color with a few simple tricks.
Script:
function GetCellColorCode(input)
{
var ss = SpreadsheetApp.getActiveSpreadsheet();
var cell = ss.getRange(input);
var result = cell.getBackground();
return result
}
Color Cell Code:
=GetCellColorCode("B"&ROW())
Check out the full guide on TechJunkie.com!
https://www.techjunkie.com/filter-by-color-google-sheets/
Music:
Dixxy - last time
https://soundcloud.com/dixxy-2/last-time