countif function

[Dave]

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.

 

[Pete_UK]

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

 

[Dave]

I tried using the =CFColorCount and got a "invaild text" message. Where are
the Color Index values found? Or do I have to use VB instead of a excel
function?

 

[Gary''s Student]

See:

http://www.xldynamic.com/source/xld.CFConditions.html

 

[Glenn]

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.

If it is only when a cell exceeds a value, maybe something like this could help:

http://www.savefile.com/files/1996219