Return amount of cells of certain background color in the range. Return amount of cells of certain background color in the range. Syntax: COUNT_COLOR (this_range, color_cell)
Description: Return amount of cells of certain background color in the range whether has value in it or not.
Argument:
this_range Count range.
color_cell Referent cell which the backgroud color need to count.
¡ïRemark: You can not select entire row or column.
Instance :
As the follow picture: Get the count of cells of green backgroud color, write a formula ": =CountColor(B2:D7,B7)"; and the yellow's is "=CountColor(B2:D7,B2)".
