How to Count Colored Cells in Google Sheets (3 Methods)

A woman pointing to the Formula to count colored cells in Google Sheets

Google Sheets doesn’t have a native formula for counting cells by background color. This guide covers three practical workarounds: a custom Apps Script function, a no-code filter method, and a third-party add-on with step-by-step instructions for each.

How To Highlight Duplicates in Google Sheets

Highlight duplicates in Google Sheets with a single formula.

Highlighting duplicates in Google Sheets takes one formula and a conditional formatting rule. This guide shows how to do it in a single column, across multiple columns, and for entire duplicate rows, including how to flag only the second occurrence, combine multiple conditions, and fix the two most common reasons the formula stops working.