Select cells that have the same background color in the sheet.
Listing updated:November 27, 2023
Works with:
AliceKeeler Select the Cells will highlight all the cells on a sheet that match the same background color. Single click on a cell with a background color. Run the Add-on from the Extensions menu to select all of the other cells with the same background within the active range. Apply actions to the entire selected range at once, for example changing the background color of the cells.

Note: This only applies to the active range. Adding a background color to cells does not determine the active range. Add text to at least one cell. The active range is a rectangle from A1 to the last row and last column with text. If cells have a background color outside of the active range they will not be selected. 

AliceKeeler Select the Cells is created by Google Developer Expert Alice Keeler. It collects NO user data. NO PII. Check out more of her Add-ons at
Additional information
PricingFree of charge
Privacy policy
Terms of service
AliceKeeler Select the Cells will ask for the permissions shown below. Learn more
AliceKeeler Select the Cells will need access to your Google account
This will allow AliceKeeler Select the Cells to :
View and manage spreadsheets that this application has been installed in
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Clear search
Close search
Google apps
Main menu