Counting colored cells

Daniel · Oct 1, 2003

I need to count the number of rows (or cells) that are are
a particular color. ex: How many cells in column A are
red?

Chip Pearson · Oct 1, 2003

Daniel,

You need a VBA function to do this. See the CountByColor function at
http://www.cpearson.com/excel/colors.htm .