D Daniel Oct 1, 2003 #1 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?
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?
C Chip Pearson Oct 1, 2003 #2 Daniel, You need a VBA function to do this. See the CountByColor function at http://www.cpearson.com/excel/colors.htm .
Daniel, You need a VBA function to do this. See the CountByColor function at http://www.cpearson.com/excel/colors.htm .
