M
machelleh2
I am trying to do a countif formula that will count all the cells in a
range that is a certain color.
range that is a certain color.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
I
immanuel
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.
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.
J
J.E. McGimpsey
C
Chip Pearson
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.
in question. See the CountByColor function at
www.cpearson.com/excel/colors.htm for example code.