Add your workbook
Choose an XLSX or XLSM file. The workbook is read locally so you can inspect its stored formatting without changing the source file.
EXCEL COLOR COUNTER
Count Colored Cells in Excel
Upload an Excel workbook, choose a worksheet and range, then count cells by fill color or font color without writing formulas or VBA.
Workbook
—
Results
Color summary
| Color | Hex | Count | Non-empty | Numeric sum |
|---|
✓ No formulas or VBA✓ Browser-local workbook reading✓ Original file unchanged
HOW IT WORKS
How to Use Motricialy Count Colored Cells in Excel
Choose sheet and range
Pick the worksheet, keep the detected used range or enter a smaller range, and choose whether to count fill colors or font colors.
Review the color counts
See every detected color with its count and numeric total, then copy the summary or download the results as CSV.
FEATURES
Key Features for Color-Coded Excel Data
Fill color counts
Group stored cell background colors and see how many cells use each color in the selected range.
Font color counts
Switch to font colors when your workbook uses colored text instead of colored cell backgrounds.
Worksheet and range control
Analyze one sheet at a time and narrow the scan to the exact Excel range that matters.
Empty-cell option
Include deliberately colored blank cells or count only cells that contain a stored value or formula.
Numeric totals by color
Alongside the count, see the sum of numeric cells that share each detected color.
Local workbook analysis
The tool reads the workbook in your browser and does not overwrite or regenerate your original Excel file.
EXCEL COLOR GUIDANCE
What the Color Counter Reads
This tool counts colors stored in standard Excel cell styles, including direct fill colors and direct font colors. It resolves RGB, indexed, and workbook theme colors, and it can include styled blank cells inside the selected range.
Colors produced only by conditional formatting rules are different: Excel calculates those colors from the rule and the current cell value rather than storing the visible result as a normal cell fill. The tool detects conditional formatting and warns you, but it does not evaluate those rules. Table banding and other style effects that are not stored as ordinary cell formatting are also excluded.
QUESTIONS
Count Colored Cells in Excel FAQ
Can Excel count colored cells with COUNTIF?
Excel does not have a normal COUNTIF criterion for a cell's displayed fill color. This tool reads stored workbook formatting directly and summarizes the colors without adding formulas or macros.
Does the tool count blank cells that have a fill color?
Yes. “Include empty colored cells” is on by default, so a blank but deliberately formatted cell can still be counted. Turn it off when you only want colored cells containing a value or formula.
Does it count colors created by conditional formatting?
No. Conditional formatting requires evaluating Excel rules, formulas, and priorities to reproduce the displayed color. The tool warns when those rules are present so you do not confuse stored style counts with conditional-format results.
Can I count colors in only part of a worksheet?
Yes. Enter a range such as A2:H250. The tool limits each scan to a practical number of cells so unusually large used ranges do not freeze the browser.
Will this tool modify my Excel workbook?
No. It reads XLSX or XLSM workbook structure for analysis and leaves the original file unchanged. The optional download is a CSV summary of the counts, not a rewritten workbook.