Excel Forum
Similar Content
Highlight Cells with Text or Formulas (non-empty cells)
Macro: This macro will highlight all cells in excel which are not empty. This means that if a cel...
Count the Visible Rows in a Filtered List in Excel
Tutorial: How to use the COUNT function on a filtered list of data so that hidden rows are not incl...
SUBTOTAL Function - Work on Filtered Data in Excel
Tutorial: Perform basic functions on a filtered dataset in excel, including SUM, AVERAGE, COUNT, COU...



Excel Magic Trick 770: Count Cells With Color Using Filter Feature or SUBTOTAL function


Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
See how to use the Filter feature and the SUBTOTAL function to count cells a given color.





Got a Question? Ask it Here in the Forum.