CountIf

[machelleh2]

I am trying to do a countif formula that will count all the cells in a
range that is a certain color.

 

[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.

 

[J.E. McGimpsey]

Take a look at

http://www.cpearson.com/excel/colors.htm

 

[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.