Excel Hack 42: Count cells by cell color
You probably may have received a 5,000 row database containing cells with multiple fill colors, and you really just want to find out how many cells are colored with a specific fill color. There are two ways to get this done. Approach 1: Create a table (select the entire range of data and Ctrl+T) or