Tuesday, March 10, 2009

Part 2: Counting cells based on interior color of the cell & Value

In the previous post we discussed about counting cells based on color now there is extension to include color and values both or only color.

= CountColorCode(RangeArea As Range, Criteria_Cell As Range, Optional Consider_Value As Boolean = False)

Criteria_Cell is Range where we need to look for colored cells and count themcRange is the criteria range, which needs to be searched
Consider_Value is bollen True/False if left alone default is False and value of cell is not taken in consideration

Download the file for codes and example




<

No comments:

Post a Comment