Filtering By Color in Google Sheets! - TechJunkie
While 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()) Date: 2022-03-28
