M machelleh2 Oct 10, 2003 #1 I am trying to do a countif formula that will count all the cells in a range that is a certain color.
I am trying to do a countif formula that will count all the cells in a range that is a certain color.
I immanuel Oct 10, 2003 #2 You'd have to create a user-defined function to get the color of a cell -- XL doesn't include any standard function that return the color of a cell. Is the color of the cell dependent on some criteria? If so, you could do a sum(if()) using that criteria instead... Post if you need help constructing the conditional sum statement. /i.
You'd have to create a user-defined function to get the color of a cell -- XL doesn't include any standard function that return the color of a cell. Is the color of the cell dependent on some criteria? If so, you could do a sum(if()) using that criteria instead... Post if you need help constructing the conditional sum statement. /i.
C Chip Pearson Oct 10, 2003 #4 You need to use VBA function in order to read the color values of the cells in question. See the CountByColor function at www.cpearson.com/excel/colors.htm for example code.
You need to use VBA function in order to read the color values of the cells in question. See the CountByColor function at www.cpearson.com/excel/colors.htm for example code.
