If you have a list with cells of all different colors, you can apply a filter to those cells to have Excel filter them by color, and then apply a formula to count how many of those cells are visible. First, select your list. Right click and choose Filter | Filter by Selected Cells Color. You can then select the filter drop down in your list's first cell and choose which … [Read more...]