countif function
Normally you would use the CF criteria as the condition in the
conditional count. However, if each CF condition has a different value
then this would be difficult. Can you have a column which contains the
value which triggers the CF, rather than embedding it within the CF
formula? Then you could make use of this value to determine which
cells to count.
Hope this helps.
Pete
On Feb 5, 4:49*pm, Dave wrote:
I have a range of cells that conditional formating will change color when a
cell exceeds a value. Each cell has a different value it will change on. How
do I count for example the number of cells in that range that are colored red
or green by conditional formatting.
|